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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Alternate state issue

Hi,

I have dashboard and in that 4 sheets are there. In one of the sheet list box is there and if i select value that value should be reflected to that particular sheet objects only.

For this one I have created one alternative state. After that I went to sheet properties and selected that alternative state name. In the same sheet also to I have alternative state to the particular chart.

The problem is alternative state is working for sheets. But if i select a value from list box that chart values are not getting affected. Previously(before implemented alternative states) it was affecting. Can anyone tell me why it is not working.

Regards,

Kumar

15 Replies
Anonymous
Not applicable
Author

hello experts,

any suggestions on this issue.

swuehl
MVP
MVP

Remove the default state identifier $ from the set expression:

count({<[SiteVisit Orders Flag]={1}>}[Site Visit Vis Num])


or use the alternate state for year field


count({$<[SiteVisit Orders Flag]={1}, Year = AS::Year >}[Site Visit Vis Num])

Anonymous
Not applicable
Author

No luck on this.

swuehl
MVP
MVP

Could you describe the issue a bit more detailed?

You selected AS alternate state in both the chart and the list box general tab, right?

What is the dimension in your chart?

Your only expression is

count({$<[SiteVisit Orders Flag]={1}>}[Site Visit Vis Num])



If you change to

count({<[SiteVisit Orders Flag]={1}>}[Site Visit Vis Num])


or

count({AS<[SiteVisit Orders Flag]={1}>}[Site Visit Vis Num])



and then change values in your list box in AS state, you see no change in the expression values?

Or there is a change, but not as expected?

Anonymous
Not applicable
Author

Yes, I have selected AS in both charts.

My dimension is Time Full Date.

swuehl
MVP
MVP

If your issue persists, please upload a small sample QVW.