topic Re: Alternate States Use in QlikView

Alternate States Use

Anonymous — Mon, 11 Jun 2018 14:50:38 GMT

Hi All,

I want to know if i can use any other identifier in below expression . I totally understand use of $ in below . If i understand it correctly, AssetClass=$:: AssetClass allows AssetClass dimension to come under StateA bucket and result will depend on selection of AssetClass now.

=sum({StateA <AssetClass=$:: AssetClass> }[Notional 2])

But i want to understand is there is any other identifier other than $ which can be used in above expression.

Re: Alternate States Use

sunny_talwar — Mon, 11 Jun 2018 14:53:40 GMT

Sure... you can use this

=Sum({StateA <AssetClass=StateB::AssetClass>}[Notional 2])

Or this

=Sum({StateA <AssetClass=$1::AssetClass>}[Notional 2])

Re: Alternate States Use

Anonymous — Mon, 11 Jun 2018 15:02:59 GMT

Hi Sunny ,

For,

=Sum({StateA <AssetClass=StateB::AssetClass>}[Notional 2])

Sum({StateA <AssetClass=StateB::AssetClass>}[Notional 2]) - Is it mean that State will be affected even if Asset Class comes under StateB.

=Sum({StateA <AssetClass=$1::AssetClass>}[Notional 2])

In this , if Asset class in not under any state then , it will work as per next selection.

Let me know if my understanding is correct about this.

Re: Alternate States Use

sunny_talwar — Mon, 11 Jun 2018 15:06:46 GMT

Is it mean that State will be affected even if Asset Class comes under StateB.

What do you mean "State will be affected". I am not sure I understand your question

Re: Alternate States Use

Anonymous — Mon, 11 Jun 2018 15:16:45 GMT

=Sum({StateA <AssetClass=StateB::AssetClass>}[Notional 2])

Could you please explain me how this above expression will work.

Re: Alternate States Use

sunny_talwar — Mon, 11 Jun 2018 15:21:24 GMT

Assuming you have three states in your dashboard

1) Default/Inherited

2) StateA

3) StateB

The above expression will not change based on any selection in Default/Inherited State. It will change based on all selections in StateA except for AssetClass field. It will only change based on direct selection in AssetClass field from StateB. Does this clarify your doubt?

Re: Alternate States Use

Anonymous — Mon, 11 Jun 2018 15:22:33 GMT

=Sum({StateA <AssetClass=StateB::AssetClass>}[Notional 2])

Could you please explain me how this above expression will work.

Re: Alternate States Use

sunny_talwar — Mon, 11 Jun 2018 15:30:58 GMT

Just did... please look below

Re: Alternate States Use

Anonymous — Mon, 11 Jun 2018 15:34:29 GMT

Thanks, It clarify my doubt

Re: Alternate States Use

Anonymous — Fri, 20 Jul 2018 09:35:30 GMT

Hi Sunny ,

If i use the function "=Sum({StateA <AssetClass=$1::AssetClass>}[Notional 2])" in text box then i am getting runtime error and QV application getting closed.

Any idea why it is happening

Thanks,

Prince Panghal

Re: Alternate States Use

sunny_talwar — Fri, 20 Jul 2018 11:20:59 GMT

Why are using $1? Are you looking to capture previous selection?

Re: Alternate States Use

Anonymous — Fri, 20 Jul 2018 12:54:23 GMT

in above post , you told me that i can use this as well so just tried it in QV application.

Re: Alternate States Use

sunny_talwar — Fri, 20 Jul 2018 13:02:32 GMT

Got it... would you be able to share a sample where you see the runtime error?