topic Alternate States - Problem in QlikView

Alternate States - Problem

Fri, 03 May 2013 12:18:08 GMT

Hi Folks

I have a simple requirement relating to alternate states but it's not working.

I have a document with states: Primary and Secondary.

I have a line chart, the chart has 2 expressions:

Sum({Primary} Sales)

Sum({Secondary} Sales)

So, it should map trends of sales data over the two states, simple really.

However, the chart that is produced simply maps the Primary state for both expressions, it doesn't take any notice of the second expression being linked to the secondary state. I would have thought this would be a fundamental requirement of alternate states so I can't believe its not supported, which means that I must have something wrong in my config.

The chart is set up with a state of Inherited but I've tried setting the chart to Inherited, Default, Primary & Secondary and none of them produce the chart I want, which is to compare the trend of Primary vs Secondary.

Anybody got any ideas on what I'm doing wrong?

Nigel.

Re: Alternate States - Problem

Fri, 03 May 2013 13:08:42 GMT

Hi Nigel,

can't guess in which way your chart isn't working. May be it's only a little detail in your config.

Please find attached a simple example which is working fine. One chart with two expressions and two related listboxes "Prim" and Second".

Hope this will help you to find a way out of your trap.

Roalnd

Re: Alternate States - Problem

Sun, 05 May 2013 08:45:26 GMT

Can you paste your sheet?

Re: Alternate States - Problem

Tue, 07 May 2013 08:14:02 GMT

Hi Roland

This helped, thanks.

I think the problem was that I was mixing some expression outside of the primary & secondary states, so my actual expression was something like:

Sum( {Primary <DateNum={">=$(vStartDate)<=$(vEndDate)"}>} Sales )

It would appear that adding in the startdate/enddate comparison removes the association with Primary or Secondary states, so I'm guessing that I need to change this so that it does something like:

Sum( {Primary <DateNum={">=$(vPrimaryStartDate)<=$(vPrimaryEndDate)"}>} Sales )

Thanks for your help, much appreciated.