topic Re: set analysis expression in QlikView

set analysis expression

ssriramin19 — Mon, 31 Aug 2015 07:18:30 GMT

I have a expression which is given in background color .

=IF(MthNbr>=num(month(date#(month(today()),'MMM'))),Yellow())

There is another field called DP_LAG .So my requirement is that whenever DP_LAG is selected the values above color expression should not change.

what is happening right now is that when DP_LAG is selected color range from the above expression is not getting active. How to accommodate set analysis {<[DP_LAG]=>} in the above color expression so that when DP_LAG is selected color will not change.

Please suggest some method on this.

Thanks

Sriram

Re: set analysis expression

sunny_talwar — Mon, 31 Aug 2015 07:23:34 GMT

Try this may be:

=If(Only({1} MthNbr)>=Num(month(today())), Yellow())

=If(Only({<[DP_LAG]=>} MthNbr)>=Num(month(today())), Yellow())

Re: set analysis expression

ssriramin19 — Mon, 31 Aug 2015 07:36:03 GMT

Thanks very much on needed suggestion. It is working as expected.

Re: set analysis expression

sunny_talwar — Mon, 31 Aug 2015 07:43:54 GMT

No problem

I am glad it worked as you wanted.

Best,

Sunny