Alternate States Use

[Anonymous]

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.

[sunny_talwar · Accepted solution]

Sure... you can use this

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

Or this

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

[Anonymous]

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.

[sunny_talwar]

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

[Anonymous]

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

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

[sunny_talwar]

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?

[Anonymous]

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

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

[sunny_talwar]

Just did... please look below

[Anonymous]

Thanks, It clarify my doubt

[Anonymous]

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