topic Re: Using Alternate states in expressions in QlikView

Using Alternate states in expressions

leenlart — Thu, 18 Mar 2021 13:53:40 GMT

Hello,

I have just learned about alternate states, and I'm pretty excited about them!

However, while searching for examples on using them in expressions, I've come across some sort of dollar-sign expansion that I don't understand.

In the Qlik help doc for Examples of Alternate States in Chart Expressions there is the following example :

count({State1<Year = $::Year, Month = $::Month>} DISTINCT [Invoice Number])

What does the Year = $::Year and Month = $::Month bit mean ?

Second question, I've seen the StateName() function, are there any other alternative state specific functions ? I haven't seen any others, but it seems strange that isn't somethat that allows access the values of the alternative state...?

Thanks for any help, idea, useful links!

Re: Using Alternate states in expressions

Or — Thu, 18 Mar 2021 14:20:39 GMT

The documentation actually explains your first question...

"The QlikView Developer will keep the Year and Month selections in State1 and State2 synchronized with the Year and Month selections in the default state."

Using $::Year means passing the selection that exists in the default state.

For your second question, I'm not familiar with any other state-specific functions. Standard functions can be used to get state information, e.g. GetCurrentselections() will take a state parameter as detailed in the documentation:

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/FieldFunctions/getcurrentselections.htm

This is the QS documentation but the same syntax works in QV, though it seems they haven't updated the documentation to reflect this.