Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternative states - restrictions

Hi Everyone,

I have used alternate states to obtained the variances (movements) between two respective dates.

Please refer to my module attached (Comparatives).

In the module there are two tables:

  1. Table using: Alternate States
  2. Table without: Alternate States

Both tables work with the "vat" button but ideally I would only like one table to show the data.

Breakdown of table using: Alternate States

Label heading "Prior" is set to sum revenue according to alternate state A dates while;

Label heading "Current" is set to sum revenue according to alternate state B dates.

The above works BUT when I select the specific "cause" per the cause list box the figures differ between the two tables.

Think it is because the "cause" list box properties the alternate states are not set.

Question:

How do I include BOTH alternate states in the "cause" list box? Or any other solutions are welcome.

Thank you

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Keep the cause list box in default state and reference the cause value set in your set expressions like

sum({[State A]<Cause = p({$}Cause)>} [Revenue])

or

sum({[State A]<Cause = $::Cause >}[Revenue])

[latter will copy the selected state, first all possible values].

View solution in original post

2 Replies
swuehl
MVP
MVP

Keep the cause list box in default state and reference the cause value set in your set expressions like

sum({[State A]<Cause = p({$}Cause)>} [Revenue])

or

sum({[State A]<Cause = $::Cause >}[Revenue])

[latter will copy the selected state, first all possible values].

Not applicable
Author

Hi Swuehl,

Thank you for the response, works 100%