topic Re: Join multiple alternate states in one set analysis in QlikView

Join multiple alternate states in one set analysis

Thu, 14 Jan 2016 16:25:05 GMT

Hi everyone, I have an issue where I'd like to have two alternate states considered in one expression and I don't know if it's possible.

Here's a bit of context:

sum({<LOI={'At Risk'}>} {LoadDate} {Summary} (COUNT))

LoadDate and Summary are 2 alternate states that I need considered in this expression.

Is this possible, and if so, how?

Thanks!

Re: Join multiple alternate states in one set analysis

sunny_talwar — Thu, 14 Jan 2016 20:00:54 GMT

Try this:

Sum({LoadDate<LOI={'At Risk'}>+Summary<LOI={'At Risk'}>} COUNT)

Assuming COUNT is a field here.

Re: Join multiple alternate states in one set analysis

Tue, 26 Jan 2016 18:09:40 GMT

Sunny, using your suggestion didn't allow me to control the chart from both alternate states. I went ahead and scrapped the idea of multiple alternate states and developed around it.

Thank you!