topic Re: How to combine alternate and default state? in QlikView

How to combine alternate and default state?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 ?

Re: How to combine alternate and default state?

chinnuchinni — Wed, 21 Mar 2018 05:07:25 GMT

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

Re: How to combine alternate and default state?

Anonymous — Wed, 21 Mar 2018 05:11:43 GMT

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

Re: How to combine alternate and default state?

chinnuchinni — Wed, 21 Mar 2018 05:49:00 GMT

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

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

and use yourdefault expression.

Re: How to combine alternate and default state?

avinashelite — Wed, 21 Mar 2018 06:20:30 GMT

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%20Alternate%20States%20in%20Ch…

Re: How to combine alternate and default state?

Anonymous — Wed, 21 Mar 2018 08:41:52 GMT

Can you please send some sample application.

Re: How to combine alternate and default state?

sunny_talwar — Wed, 21 Mar 2018 09:57:18 GMT

May be this

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

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

Re: How to combine alternate and default state?

BalaBhaskar_Qlik — Wed, 29 Aug 2018 10:13:10 GMT

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