Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hello experts,
any suggestions on this issue.
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])
No luck on this.
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?
Yes, I have selected AS in both charts.
My dimension is Time Full Date.
If your issue persists, please upload a small sample QVW.