I am new to qlikview and Need help. I want to Check if for Example today -2 days was a Holiday (all written down in table Holiday) and then just give a Feedback. I cant even Write the if.. Thanks for the help!
The three parameters condition, then and else are all expressions. The first one, condition, is interpreted logically. The two other ones, then and else, can be of any type. They should preferably be of the same type. If condition is true, the function returns the value of the expression then. If condition is false, the function returns the value of the expression else.
Example:
if( Amount>= 0, 'OK', 'Alarm' )
In your case
=if( Amount>= 0, Amount, 0)
If the issue is solved please mark the answer with Accept as Solution.
The three parameters condition, then and else are all expressions. The first one, condition, is interpreted logically. The two other ones, then and else, can be of any type. They should preferably be of the same type. If condition is true, the function returns the value of the expression then. If condition is false, the function returns the value of the expression else.
Example:
if( Amount>= 0, 'OK', 'Alarm' )
In your case
=if( Amount>= 0, Amount, 0)
If the issue is solved please mark the answer with Accept as Solution.
