Title In listbox Properties

[arulsettu]

HI i am new to qlikview

in demo app i saw this in title following code 

=Only({<No={9}>} [$(=vDataLanguage)])

list box properties. what is the use of this and where the name like Product came from? because i didn't see any names mentioned..

any one can clear this doubt... thanks...

[#2]

which demo app you using?

[arulsettu]

Sales Management and Customer Analysis

[#4]

Hi,

Check the variable expression, in that it must have mentioned field on basis of which that particular name "product category" is shown.

HTH

-Shruti

[#5]

Hello Arul,

I found it.

Create a Table Box, with below fields:

No and English

you will see for each number, they have a English Text. And that text gets displayed at the Listbox title.

similary u will find fields like Japanese, English etc

[arulsettu]

hi Shruthi

          i checked the expression but there is no name

[#7]

So your Title expression becomes : =Only({<No={9}>} English)

where English is a field name. So the text corresponding to No =9, that will shown at Title

[#8]

Hi,

I checked it. It mentions "Language" which is a data field which comes from script. You can check it taking it as List box.

-Shruti

[arulsettu]

ya it looks like this...

so the number holds the name?

[#10]

try it with if

if(No=9,$(=vDataLanguage))

[#11 · Accepted solution]

Yes, it is like mapping Text with Numbers.

So in the expression you are using set analysis when you use {<No={9}>}. This means to select No as 9

and then when we embed it with Only() it returns the Text corresponding to English field name where No is 9 i.e  Product Category in your case.

Let us know, if you come across any other issue. And can close the thread if you have got all your answers.

Thanks,

Angad