topic Re: how to make a dynamic label reference an alternate state? in QlikView

how to make a dynamic label reference an alternate state?

stevelord — Mon, 08 Jul 2013 21:25:15 GMT

Hi, I have a chart that I am putting a couple of set analysis expressions into and I'd like to make the label of the alternate state expression show the name of the client selected in the alternate state.

I can make the label name =ClientAccountName and that gives me the ClientAccountName selected in the default state.

What do I put in that expression to make it show me the ClientAccountName in the State2 alternate state?

I'd like the labels to show Company A for one and Company B for the other as different companies are selected from either state.

Thanks!

-Steve

Re: how to make a dynamic label reference an alternate state?

tresB — Tue, 09 Jul 2013 04:07:34 GMT

Try this:

Only ( {State2} ClientAccountName)

Re: how to make a dynamic label reference an alternate state?

stevelord — Tue, 09 Jul 2013 13:41:22 GMT

Worked like a charm, thanks.

I'm still getting a feel for alternate state syntaxes and tackling basket analysis beasts. And this was a much needed morale boosting victory break of some kind. You gave me syntax for a chart that I managed to hammer together earlier in the day. (I think the graph works right too but I need to QA it against made-up data questions that I already know the answers to. )

Re: how to make a dynamic label reference an alternate state?

MuraliPrasath — Sat, 04 Apr 2020 05:56:40 GMT

thanks for this solution. I had same problem and got it fixed. Thanks once again!