topic Re: Filtering measures created with alternate states in App Development

Filtering measures created with alternate states

Brysonds — Mon, 21 Mar 2022 19:25:53 GMT

Hello, I have what I hope to be a simple problem:

I created two alternate states:
Period1
Period2

I then added the same period dimension to my sheet twice as filter panels and applied the alternate state to each.

I created the following variance measure:
Sum({Period1}[Sales Amount USD]) - Sum({Period2}[Sales Amount USD])

This works perfectly and shows me the total sales amount variance between whatever period(s) that I select from the filter panels. This gives flexibility to do several different time period variances without creating multiple set-analysis expressions.

However, now I have the simple request to filter the data. For example, say I want to filter by a country (i.e. US or Canada). How can I filter these measures further?

Re: Filtering measures created with alternate states

rwunderlich — Mon, 21 Mar 2022 20:36:22 GMT

Assuming you are making the other selections, like Country, in the default state, just include the default state with the intersection operator:

Sum({Period1 * $}[Sales Amount USD]) - Sum({Period2 * $}[Sales Amount USD])

If you want to make sure your period selections only come from the alternate states, add set modifiers as shown here:

https://qlikviewcookbook.com/2016/07/alt-states-merged-selections-tip/

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Filtering measures created with alternate states

Brysonds — Mon, 21 Mar 2022 21:16:49 GMT

This worked perfectly and thank you for information on the set modifiers!! 🙂