Filter pane in qliksense

[pooja821]

I need to select multiple quarter values in filter pane and upon selecting these values I need to show comparison among the values i.e. if values in quarter 1 is less than the values in quarter 2 then the text color of the values changes to red or green accordingly.

How can I do that?

[Anonymous]

Hi Pooja,

Here you are pointing two tasks.

1. Selection of Filter(Quarter)

2. Based on thew selection Q1 and Q2 the comparision should happen right.

My question was where you want to compare these values?

you can write aggregation by quarter and you can write a condition for that in sigle expression but you can see either Q1 values or Q2 values based on the condition.

Give us come clarity?

Regards,

Sadasiva

[beck_bakytbek]

Hi Pooja,

check this: https://community.qlik.com/thread/164433

i hope that helps

Beck

[ahaahaaha]

Hi,

Try to write something similar in the expression for colors in the chart

If(GetFieldSelections([YourFilterFitld], ',')= 'Q1,Q2',

If(Sum({<Quater={'Q1'}>}Value)>Sum({<Quater={'Q2'}>}Value), LightRed(), LightBlue()),

LightGreen())

Look example at attached file.

Regards,

Andrey