topic Set Analysis greater than Alternate State Selection in QlikView

Set Analysis greater than Alternate State Selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have this expression in a chart.

Sum ({<Date={'>=09/01/2017'}>} AMOUNT)

How do I replace the hard coded date of 09/01/2017 with the date selected in an alternate state?

sergio0592 — Fri, 27 Oct 2017 20:37:50 GMT

Maybe try with :

Sum ({<Date={">=$(=V_date)"}>} AMOUNT)

V_date=Only( {Alternate_State} Date)

Anonymous — Mon, 30 Oct 2017 13:43:57 GMT

That worked!

I added it as

=Sum ({<Date={">=$(=Only( {Alternate_State} Date))"}>} AMOUNT)

I'm confused on what the equals sign does before the Only function. Why is that needed?