# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

## Alternate state in calculated dimension - Set analysis

Guys,

I have two alternate states, one is <inherited> the other one is <Healthy_Food_State>...

I have one chart table that it is in the inherited stated, but I want one dimension to be in get the possible selections in the Healthy_Food_State, and then they match...

Can you guys say to me a possible expression?

I am trying something like:

=only({\$<item_substitute= ::[Healthy_Food_State]>}item_substitute)

I do suck at those kind of expressions.

Can you guys tell me a possible solution for that?

3 Replies
Not applicable

## Re: Alternate state in calculated dimension - Set analysis

=only({\$<item_substitute={Healthy_Food_State}::item_substitute>}item_substitute)

Not applicable

## Re: Re: Alternate state in calculated dimension - Set analysis

it didn't work, try to see here the attachment:

in the third blue box we have the chart called "Saving"... The calculated dimension is in there. I want to get the item_id from the other state, (i want the item_id as in the second blue box, in the blue chart called "Food Price").

Not applicable

PFA