topic Re: How to use where clause in variable settings?? in QlikView

How to use where clause in variable settings??

suvechha_b — Mon, 22 Jul 2013 19:50:19 GMT

How to write this :

=Sum({$<year1={$(vYear)}>& 'and' & $<year1={$(vMonth)}>} projectedadjustment)

in settings>>Variable Overview:

Add a variable :vData and set the above statement...

Anonymous — Mon, 22 Jul 2013 20:28:06 GMT

why is year1 equal $(vYear) and $(vMonth) ?

suvechha_b — Mon, 22 Jul 2013 20:44:14 GMT

I have to select projected adjustment depending on dimension vMonth and vYear .....

I have projected adjustment value depending on Product Code and also will depend vMonth and vYear....

Anonymous — Mon, 22 Jul 2013 20:55:59 GMT

try with this

Sum({$<year1={$(vYear),$(vMonth)}>} projectedadjustment)

Sum({$<year1={$(vYear)}, month1={$(vMonth)}>} projectedadjustment)