Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
pooja821
Contributor

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
sadasiva
Contributor II

Re: Filter pane in qliksense

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
Honored Contributor

Re: Filter pane in qliksense

Hi Pooja,

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

i hope that helps

Beck

ahaahaaha
Honored Contributor

Re: Filter pane in qliksense

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