How to combine alternate and default state?

[Anonymous]

Hi All,

I have a query regarding combing alternate state and  default state. In my dashboard i have three different charts with three different states(with three different multibox having same three different states ) but now i want other filters(Brand circled in black color) to work on all charts with default state. Following is the expression written for charts

=num(count({stateA<Year ={"$(=Max(Year)-2)"}>}DISTINCT Sold_Date),'#,##0.0')

Now how to add another state as default state in same expression ?

[chinnuchinni]

is brand button ?  you want to display the default result when you select the Brand ?

[Anonymous]

Its text box when I click on brand a list box appears as brand and yes i want to display the default result for all three charts

[chinnuchinni]

then,the easy way is,you can use calculation condition.

give the condition as, getselectedcount(brandfield)>0.

and use yourdefault expression.

[avinashelite]

check this thread for the information

Is possible to use alternate States with set analysis

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Examples%20of%20Alternat...

[Anonymous]

Can you please send some sample application.

[sunny_talwar]

May be this

=Num(Count({stateA<Year ={"$(=Max(Year)-2)"}, Brand = p({$} Brand)>}DISTINCT Sold_Date),'#,##0.0')

or

=Num(Count({stateA<Year ={"$(=Max(Year)-2)"}, Brand = $::Brand>}DISTINCT Sold_Date),'#,##0.0')

[balabhaskarqlik]

Did you resolved the issue, post it to help others.