Need help

khenising — Mon, 26 Jan 2026 21:26:37 GMT

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!

Re: Need help

Lucas_Gatling — Thu, 03 Feb 2022 15:28:39 GMT

Try using this to get today's date minus 2 days:

=date(OriginalDate-2, 'DD.MM.YYYY hh:mm:ss.fff')

From the help:

if( condition , then , else )

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)

topic Re: Need help in QlikView

Need help

Re: Need help