Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Clear Alternate states selections

Dear All,

We have implemented Alternate states in our app as below:

One set of Year/Month/Date  filters with Default state.

Other set of Year/Month/Date  filters with Alternate state name as Local1.

Created One Bar chart which can possess selections which are made from both Default and Alternate states i.e in same bar chart.

Steps of Process:

1.When User selects Year/Month/Date in Default state, Bar chart displays its values(i.e 3 Bars where dimension is monthyear and measure is sum(count)).

2.When User selects Year/Month/Date in Alternate state, same Bar chart now overrides 2nd Bar with Alternate state selections and remaining bars still hold default state selections.

Again, When User selects Default state after Alternate state selections, it should deselect all Alternate state selections which is our requirement.

"Alternate state selections should be cleared when Selecting Default selections again". Is this case possible through actions/triggers?

Please give your Valuable suggestions.

Thanks in Anticipation.

Regards,

Kishore.

7 Replies
Anonymous
Not applicable
Author

Hi Kishore,

You should be able to find solution from using something like:  sum({State} count)

or

Only and Aggr function: Aggr(Only({[State]} count), count)

Best,

Maurice

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

If you want to clear selections in an alternate state then you can use the Clear button in the menu which will clear all selections or you will have to use an object like a current selections box or list boxes that are also assigned to that alternate state. Or you can try using a button or text object with Clear or Clear Field actions to clear selections in (fields in) and alternate state.

But I don't see why you have to use alternate states. If only one set of selections should be used at a time then why not simply let the user move back and forwards through his/her selections?


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks for reply Gysbert.

We are using three Set of selections which are in different states(i.e default state ,Group1 state and Group2).

We want to clear the alternate state selections without using any object i.e button/text.

User selects Global filters(default state) initially, after that selects Local filters(Alternate states), now the chart is currently having both default and alternate state selections( i.e using multiple set of selections at a time).

Now,When again user selects default state , alternate state selections has to be cleared without using any button/text/clear all object and default state selections should get highlighted.

Please find the attachment in the main thread .

Not applicable
Author

Thanks for reply Maurice.

Here we would like to cleare alternate selections without using any button/text object.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

We want to clear the alternate state selections without using any object i.e button/text.

Then you need to use list boxes, multi boxes or current selections objects in the same alternates states.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Maybe with macros support:

Using ActiveDocument.GetField("fieldname", "State")

And then maybe proceed with ActiveDocument.Fields("fieldname", "State").Clear

Best,

Maurice

Not applicable
Author

Here expected behaviour is Alternate selections has to be cleared automatically when default selections are made, not to use any other object(button,text,list box, multi box,current selections etc) to clear alternate selections.