Default state applied to alternate state chart

[HitcH]

Hello guys,

I have a QV with two sheets.

The first (default state) one has a list box with inherited state, and one element filtered.

On the second sheet I have a chart with an alternate state, but I'm not able to modify my selections on it, as it gets the data from the list box in sheet 1.

Example:

Dimension 'People': values are 'I', 'you', 'he', 'she'...

Sheet 1 - default state

List box (inherited state) in sheet 1 - dimension 'People' I select only value 'you'

Sheet 2 - alternate state

Chart showing 'People': 'I', 'you', 'he', 'she'

I hope it is clear.

Thanks in advance for your help!

[stevejoyce]

your expressions can reference different states.  So your selection is being made in default state but your objects are in an alternate_state.  your expression can be:

sum({<People = (P{$} People)>} value)

[HitcH]

Hi Steve,

I think I understand your point, but I would like to avoid changing expression and using set analysis.

I usually have alternate states for every sheet in my QV, on each one of them I use different filters, I just don't understand why on this sheet my filter is linked to the default state, and how could I "separate" them.

Can you help me with this?

Thanks again! 🙂

[stevejoyce]

Can you make sure each object is set to state Inherited.  There's a hierarchy of state inheritance, but assuming it's just a list box on a sheet (no container) it will be in the same state as your sheet.

[HitcH]

Apparently not.

As you can see, my chart has the alternate state "BB", and dimension "Canale" is showing 5 different values

Still, the current selection box (with alternate state "BB") has only one value selected for dimension "Canale":

So I don't understand why I see 5 of them in the first chart

[stevejoyce]

Is your table's expressions ignoring selections Or using $ in them {$} that is looking back to your default state. 

[HitcH]

Hi Steve,

In my expression I'm using a set expression with $ but it is referred to a different dimension.

I understand now that probably this has an impact also on other dimensions:

(sum({$<[Calendar year] = {2020}>} [Expression])

This one above is one of the expressions that I'm using. How should I modify the syntax in order to "fix" the year and to have the other dimension operating on the alternate state?

Thanks again, I think that we are close to the final solution 😄

[stevejoyce · Accepted solution]

Yes that's impacting it, that is for the entire set.  I'm not sure why you need $ if you are hard coding to 2020, but if you want your alt state to use the Calendar year from default state, you can do this:

sum({<[Calendar year] = P({$} [Calendar year]) >} [Expression])

[HitcH]

Thank you very much Steve.

Actually, it was not really needed to use the $ on the calendar year. I simply removed it and now it is working fine.

I really appreciated your help!! Have a nice day 🙂