Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Join multiple alternate states in one set analysis

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!

2 Replies

Re: Join multiple alternate states in one set analysis

Try this:

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

Assuming COUNT is a field here.

Not applicable

Re: Join multiple alternate states in one set analysis

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!