Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pooja821
New Contributor III

Changes at third time selection of quarter

I have four columns, Q1, Q2, Q3, Q4 and the data which changes according to the quarter selected along with showing the comparison between the values of previous selected quarter and the current selected quarter.

If the value in current selected quarter is less then the previous selected quarter then the color of the text changes to red else green.

Now I want is that initially(When no quarter is selected) my text color should be none and on selecting the quarter first time also the text color should not change, While on selecting the quarter second time my text color should change and should show the comparison between the values.

Kindly help...

1 Reply
Luminary
Luminary

Re: Changes at third time selection of quarter

Hello! Sounds like you could use GetSelectedCount‌‌‌ for the color expression, e.g. something like:

If(GetSelectedCount(Quarter) > 1, Your color expression, White())

Community Browser