variable display and if condition

Mon, 13 Feb 2012 07:10:02 GMT

1. How do we get variable values displayed in qlikview?

Eg:

varToday = DATE(today(),'YYYY-MM-DD');

I want to see the value assigned to varToday.

2. I would also like to know how "if condition" works in qlikview.

Eg: File1=upper(date(if(match(num(weekday('$(varToday)')),0,1),'$(varToday)'-4,'$(varToday)'-2), 'DDMMM'))

What will be the value in File1?

Thanks

variable display and if condition

CELAMBARASAN — Mon, 13 Feb 2012 07:22:54 GMT

Hi,

1. For getting the value of the variable you can use the variable name inside dollar expansion like $(varToday) in a text object or anything else.

2. You can use condition like If($(File1)<Today(),$(File1),Today())

File1 has the text upper(date(if(match(num(weekday('$(varToday)')),0,1),'$(varToday)'-4,'$(varToday)'-2), 'DDMMM')) if you used SET keyword before it.If you use LET then it has the value returned by the method.

LET computes the value and set to the variable.

SET set the value as expression you assigned and you need to compute it using $(=varToday).

Hope it helps

Celambarasan

topic variable display and if condition in QlikView

variable display and if condition

variable display and if condition