(Multiple) Alternate States or in expression

[tcjwpeeters]

Hi all,

I'm struggling with Alternate States and/or using them in Expressions.

I have a downtime app with a "Structural Top 3" sheet for daily/ weekly/ monthly follow-up.

The three Selection Filter panes and the graphs are connected with 3 individual Alternate States.

But the graphs should also be affected by the top filter pane, because the Top 3 should be possible to be viewed by area.

I have tried to incorporate the Alternate States into the expressions, but then the graphs don't change based on the Topx Selections. I tried adding *$ in the expression but that doesn't seem to do the trick either.

Sum({[Top1 Selection * $]}{<FunctionalLocation = {"*BS-*"}>} Downtime)/60

Do I have to change the Alternate States of the graphs to <inherited>  or something when I do this?

Could you please provide me with some tips on how to use Alternate States in this case?

Thanks in advance

Greets,

Tom

[MayilVahanan · Accepted solution]

Hi @tcjwpeeters 

Try like below

Sum({[Top1 Selection]}{<Year = $::Year, Month = $::Month,FunctionalLocation = {"*BS-*"}>} Downtime)/60

now, its will reflect for Year & month also. Similiarly, you can change accordingly

FYR:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Examples%20of%2...

[tcjwpeeters]

Hi MayilVahanan,

Thank you, for Fields like Year etc. this works fine.

But the one parameter which I would require to affect the graphs is "Rayon" in the top-left corner.

Rayon is a selfmade dimension which WildMatches FunctionalLocations.

If I use your formula on FunctionalLocation it doesn't change the graphs when selecting a specific "Rayon";

Sum({[Top1 Selection]}{<FunctionalLocation = $::FunctionalLocation>} Downtime)/60

any thoughts?

[tcjwpeeters]

Hi MayilVahanan,

thank you for your solution.

THe existing problem with the selfmade dimension will be solved in the script at our Back-end.

Greets,

Tom