topic Re: dynamic label? in QlikView

dynamic label?

Thu, 22 Sep 2016 10:58:29 GMT

HI All,

I have list box name flag having, Prim & Sec..

I select Prim in List box Straight table Label should come as Prim.

I select Sec in List box Straight table Label should come as Sec

Regards,

Helen

Re: dynamic label?

amit_saini — Thu, 22 Sep 2016 11:00:22 GMT

Hi,

See the attachment.

Thanks,

Re: dynamic label?

Thu, 22 Sep 2016 11:15:19 GMT

Try something like this :

if (getfieldselections(flag)='Prim','Prim','Sec') in Title of the chart.

Regards,

Balakrishnan.R

Re: dynamic label?

nagarjuna_kotha — Thu, 22 Sep 2016 11:38:17 GMT

Like this :

We have two ways achieving this :

1. Normal Field in Label Like "=Field"

2.Using GetFieldSelections

See attached.

Hope this may help.

Regards,

Nagarjun !

Re: dynamic label?

avinashelite — Thu, 22 Sep 2016 11:47:25 GMT

Add this expression in the chart label

Getfieldselections(flag)

Re: dynamic label?

Thu, 22 Sep 2016 11:58:56 GMT

With in the Flag what ever i will match, i need to show that Name..

Example: Flag =Prim, then i need show label name as Sales

Flag =Sec, then i need show label name as PriSales

Regards,

Helen

Re: dynamic label?

adamdavi3s — Thu, 22 Sep 2016 12:10:22 GMT

use = pick(match(flag,Prim,Sec),'Sales','PriSales')

Sorry I might have the syntax a little off but it should be close

Re: dynamic label?

avinashelite — Thu, 22 Sep 2016 12:11:27 GMT

Try like this

if(trim(Getfieldselections(flag))='Prim','Sales',if(trim(Getfieldselections(flag))='Sec','PriSales','Default_Msg'))

Re: dynamic label?

adamdavi3s — Thu, 22 Sep 2016 12:16:30 GMT

I'm interested to discuss but I would always use pick(match( over IF statements where possible, IF statements are really inefficient....

this is the correct formula: =pick(match(flag,'Prim','Sec'),'Sales','PriSales')

Re: dynamic label?

avinashelite — Thu, 22 Sep 2016 12:24:57 GMT

with limited values both would perform the same(i.e with the current scenario we have only 2 values), with the large data comparison I would prefer using the Pick and match combination ..hope this make sense

Re: dynamic label?

adamdavi3s — Thu, 22 Sep 2016 12:48:12 GMT

True with the limited values the difference is impossible to tell.

pick match is much shorter I guess, but the IF has the added benefit of having a default value