topic Re: Alternate State Expressions taking Default State Selections in QlikView

Alternate State Expressions taking Default State Selections

Anonymous — Mon, 16 Jul 2018 15:11:03 GMT

I am using Alternate States in order to create dynamic week over week comparisons, by creating an alternate state for two different week selections. I would love if I could also have my expressions take field selections that occur in the default state, and I know I can use a syntax similar to the following to accomplish this:

Sum({OldWeek <Inventory_Type= $::Inventory_Type>} Inv_Total_Cost)

Is there any other way of accomplishing this, without listing every field in the default state in the chart expression like this? I am picturing a solution with field selection trigger that copy over selections to the two alternate states, but this seems clunky as well. I have dozens of fields that I would want to filter my alternate state expressions on, so I am hoping for a more elegant solutions that doesn't blow up my chart expressions into 100's of lines each.

Thanks!

Re: Alternate State Expressions taking Default State Selections

sunny_talwar — Mon, 16 Jul 2018 15:22:40 GMT

How about this? This will honor selections in all fields from OldWeek and $...

Sum({OldWeek*$} Inv_Total_Cost)

if you want to ignore some from inherited state... you can do this

Sum({OldWeek*$<Field1, Field2, Field3>} Inv_Total_Cost)

Re: Alternate State Expressions taking Default State Selections

Anonymous — Mon, 16 Jul 2018 15:32:52 GMT

This is exactly what I was looking for, Thank You so much!