if - script and chart function

The if function returns a value depending on whether the condition provided with the function evaluates as True or False.

Syntax:

if(condition , then , else)

The if function has three parameters, condition, then and else, which are all expressions. The two other ones, then and else, can be of any type.

Arguments:

Argument	Description
condition	Expression that is interpreted logically.
then	Expression that can be of any type. If the condition is True, then the if function returns the value of the then expression.
else	Expression that can be of any type. If the condition is False, then the if function returns the value of the else expression.

Qlik Sense table showing an example of the if function.

Example	Result
if( Amount>= 0, 'OK', 'Alarm' )	This expression will test if the amount is a positive number (0 or larger) and return 'OK' if it is. If the amount is less than 0, 'Alarm' is returned.

Chart expression

Qlik Sense table showing examples of the if function in a chart expression.

Date	Location	Incidents	if(Incidents>=10, 'Critical', 'Ok' )	if(Incidents>=10, 'Critical', If( Incidents>=1 and Incidents<10, 'Warning', 'Ok'))
1/3/2016	Beijing	0	Ok	Ok
1/3/2016	Boston	12	Critical	Critical
1/3/2016	Stockholm	3	Ok	Warning
1/3/2016	Toronto	0	Ok	Ok
1/4/2016	Beijing	0	Ok	Ok
1/4/2016	Boston	8	Ok	Warning

Load script

If can be used in load script with other methods and objects, including variables. For example, if you set a variable threshold and want to include a field in the data model based on that threshold, you can do the following:

Transactions: Load * Inline [ transaction_id, transaction_date, transaction_amount, transaction_quantity, customer_id, size, color_code 3750, 20180830, 23.56, 2, 2038593, L, Red 3751, 20180907, 556.31, 6, 203521, m, orange 3752, 20180916, 5.75, 1, 5646471, S, blue 3753, 20180922, 125.00, 7, 3036491, l, Black 3754, 20180922, 484.21, 13, 049681, xs, Red 3756, 20180922, 59.18, 2, 2038593, M, Blue 3757, 20180923, 177.42, 21, 203521, XL, Black ]; set threshold = 100; /* Create new table called Transaction_Buckets Compare transaction_amount field from Transaction table to threshold of 100. Output results into a new field called Compared to Threshold */ Transaction_Buckets: Load transaction_id, If(transaction_amount > $(threshold),'Greater than $(threshold)','Less than $(threshold)') as [Compared to Threshold] Resident Transactions;

Results

Qlik Sense table showing the output from using the if function in the load script.

transaction_id	Compared to Threshold
3750	Less than 100
3751	Greater than 100
3752	Less than 100
3753	Greater than 100
3754	Greater than 100
3756	Less than 100
3757	Greater than 100

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here