Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pooja821
Creator
Creator

Filter pane in qliksense

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?

3 Replies
Anonymous
Not applicable

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
Master
Master

Hi Pooja,

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

i hope that helps

Beck

ahaahaaha
Partner - Master
Partner - Master

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