topic dynamic selection in QlikView

dynamic selection

manoranjan_d — Tue, 18 Jul 2017 13:34:25 GMT

i want to give the expression label name with dynamic selection of the week

example if i select the week1 in the list box 1, since list box 1 has been defined with state1

then the expression label has to show "week1 total amt"

but this is not working

=Only({[State1]}if(GetSelectedCount(Week_Num1)>=1,Week_Num1,'Week')) & 'total amt'

its not showing

its showing only "week total amt" but as per the requirement is shd show

"week1 total amt"

bcoz i slected week1 from list box 1 assigned with state1

Anil_Babu_Samineni — Tue, 18 Jul 2017 13:37:23 GMT

What if you use some thing like below

=GetFieldSelection(Week_Num1) & 'total amt'

manoranjan_d — Tue, 18 Jul 2017 13:39:25 GMT

week_num1 field has been assigned list box with alternate state

manoranjan_d — Tue, 18 Jul 2017 13:41:55 GMT

in this expression how to give the state1

effinty2112 — Tue, 18 Jul 2017 13:49:42 GMT

Hi,

Try this:

=Only({[State 1]} if(GetSelectedCount(Week_Num1, 'include','State 1') =1,Text(Week_Num1),'Week')) & 'total amt'

cheers

Andrew