Display the value of the Alternate State if it is not a number

[Anonymous]

Hi Qlikview Experts,

Been using alternate states but one thing that seems simple but I can't do is display the values of the different alternate states. As we know, we would use a function like SUM({State1}COST) to display the [COST] of the alternate state, State1.

But how do I pull the value if it is a name? For example in State1, the Field, [NAME] is equal to "MARK", how can I display the value "MARK"? SUM({State1}NAME) obviously would not work.

Thanks experts! Hoping for the assistance!

[senpradip007]

Try like SUM({State1<NAME={"MARK"}>}COST)

[tresesco]

Not really sure what are trying to get. If you are just looking to display the name, perhaps you can try like:

Only({State1<NAME={MARK}>}NAME)

[Anonymous]

My objective is to display the value for [NAME] of Alternate State, {State1}. The values of the field, [NAME], are non-numeric; hence, if I do something like SUM({State1}NAME), it would only result in a zero.

[jonathandienst · Accepted solution]

No, but Concat should:  =Concat({State1}NAME, ', ')

[Anonymous]

Awesome! Thanks!