topic Re: Alternate state issue in QlikView

Alternate state issue

Anonymous — Thu, 20 Aug 2015 09:20:36 GMT

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

Re: Alternate state issue

tresB — Thu, 20 Aug 2015 09:24:13 GMT

Why don't you change the state of the list box too?

Re: Alternate state issue

Anonymous — Thu, 20 Aug 2015 09:28:55 GMT

Sorry, Even I changed that listbox state also

Re: Alternate state issue

sundarakumar — Thu, 20 Aug 2015 09:31:23 GMT

Make sure both the list box and chart are in the same alternate states in the properties.

Regards,

sundar

Re: Alternate state issue

Anonymous — Thu, 20 Aug 2015 09:37:58 GMT

Pls see the screen shots

Re: Alternate state issue

sundarakumar — Thu, 20 Aug 2015 09:44:08 GMT

Pls check if the chart is detached, Detached charts are unaffected by selections. Or you could have written expression in such a way to ignore the selections. Pls check it once with normal sum(sales) kind of expressions. If the issue still persist pls share a sample app.

Thanks

-Sundar

Re: Alternate state issue

Thu, 20 Aug 2015 10:55:24 GMT

Please check the chart is detached and the expression in chart developed by set analysis full set '1'

kindly remove the detached and full set in expression

Re: Alternate state issue

Anonymous — Thu, 20 Aug 2015 11:03:14 GMT

There is no chart detached. Expression is

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

Re: Alternate state issue

Thu, 20 Aug 2015 11:05:35 GMT

Which field are you used in list box

Re: Alternate state issue

Anonymous — Thu, 20 Aug 2015 11:08:13 GMT

I used time field. it is an expression like

if(time>=2000,time)

Re: Alternate state issue

Anonymous — Thu, 20 Aug 2015 16:37:40 GMT

hello experts,

any suggestions on this issue.

Re: Alternate state issue

swuehl — Thu, 20 Aug 2015 16:55:17 GMT

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])

Re: Alternate state issue

Anonymous — Fri, 21 Aug 2015 12:41:43 GMT

No luck on this.

Re: Alternate state issue

swuehl — Fri, 21 Aug 2015 13:02:29 GMT

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])

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?

Re: Alternate state issue

Anonymous — Fri, 21 Aug 2015 13:44:43 GMT

Yes, I have selected AS in both charts.

My dimension is Time Full Date.

Re: Alternate state issue

swuehl — Fri, 21 Aug 2015 17:57:14 GMT

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