can a filter pane has 2 alternative states?

[xingstar97]

I have KPI chart 1 and KPI chart2. I also have filter pane 1 and filter pane 2. I hope filter pane 1 only applies to chart 1, but filter pane 2 applies to both chart1 and chart2.

I'm considering using alternative states, assigning chart 1 to group 1 and chart 2 to group 2. I'll also assign filter pane 1 to group 1. But I'm wondering if I can assign filter pane 2 to both group 1 and group 2, or if I have to choose one group.

If alternative state doesn't work for me, is there any other approaches?

[PhanThanhSon]

Hi,

Personaly i dont work with alternate states, because i dont like them. But this works for me:

Where the variable is defined as:

vTwoAlternateState

=concat(distinct {[State1]} chr(39)&Year&chr(39), ',') & ',' & concat(distinct {[State2]} chr(39)&Year&chr(39), ',')

And Measure defined as:

Sum({<Year = {$(=vTwoAlternateState)}>} Einzelpreis)

See also this:

Alternate States for Comparative Analysis in Qlik ... - Qlik Community - 2066081

Best regards Son

[anat]

 you can bypass filterpane1 in chart2 

[xingstar97]

Could you please clarify how to do it? Thanks!

[anat]

chart2 expression : sum({<Filterpane1=>}sales)

[robert99 · Accepted solution]

@xingstar97 

Its something that I was surprised recently (using alternate states) still hasn't been done by Qlik. Maybe its complex to do but its seems it would be a very simple change to make.

Anyway thats the way it is. It's requested under >> Support >> Ideation

What I did was this as recommended somewhere on the forum

I had 8 filters set up based on the inherited state and applied it also to the alternate state measure  as follows (MthYr_State is the alternate state)

NB. It would be much easier to set up a filter and instead of applying it to alternate state measures as shown below. apply it to 2 or more 'states' in the actual filter pane.

But the below worked well enough but just took time to set up

Count ({[MthYr_State]
< Call_Catagory = $::Call_Catagory ,                      EngWalesScot1st = $::EngWalesScot1st
,FSREmpCategory1st = $::FSREmpCategory1st, FieldEng_1st = $::FieldEng_1st
,FSREmpNum1st = $::FSREmpNum1st ,                FSREmpName1st = $:: FSREmpName1st
,FTF_YN = $::FTF_YN ,                                             Geo_Region1st =$:: Geo_Region1st
,CanonType = {Call_C}, GroupFSR = {FSR},Call_Status ={COMP}
, Year *= {$(vYear)} ,YearFin *= {$(vYearFin)} //variable to reduce yrs shown
>} distinct Call_Num )