Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ssriramin19
Contributor III
Contributor III

set analysis expression

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

1 Solution

Accepted Solutions
sunny_talwar

Try this may be:

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


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

View solution in original post

3 Replies
sunny_talwar

Try this may be:

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


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

ssriramin19
Contributor III
Contributor III
Author

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

sunny_talwar

No problem

I am glad it worked as you wanted.

Best,

Sunny