topic Title In listbox Properties in QlikView

Title In listbox Properties

arulsettu — Thu, 23 Jan 2014 06:16:42 GMT

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...

Re: Title In listbox Properties

sujeetsingh — Thu, 23 Jan 2014 06:22:18 GMT

Arul,

I do not get what you are talking about ,

well the expression uses the Set modifier for the No=9and call variable vDataLanguage

Re: Title In listbox Properties

Thu, 23 Jan 2014 06:24:41 GMT

In the expression, they are using a variable: vDataLanguage.

Go to Settings and Variable Overview, you would find its value.

Re: Title In listbox Properties

arulsettu — Thu, 23 Jan 2014 06:27:02 GMT

this img in title they calling variable right?

Re: Title In listbox Properties

tresB — Thu, 23 Jan 2014 06:27:21 GMT

vDataLanguage is a variable which holds the mystery. Goto Settings->Variable Overview, you will find what the variable contains. Rest is set analysis to say get that variable expression value when a 'No' field has a value 9.

Re: Title In listbox Properties

arulsettu — Thu, 23 Jan 2014 06:29:51 GMT

hi itsangad,

the variable having some value so what is the use of this code?

Re: Title In listbox Properties

Thu, 23 Jan 2014 06:34:12 GMT

This expression would return the value of that variable when No =9

{No=9} will act as a filter or where clause as in database language.

Re: Title In listbox Properties

arulsettu — Thu, 23 Jan 2014 06:37:12 GMT

Where is to rest is set analysis and where is the Product Category name came from?

Re: Title In listbox Properties

Thu, 23 Jan 2014 06:39:43 GMT

The expression is used in Title section.

Please look below, the Field Section. There you will find the ProductCategoryName field. This the field which is populating the data.

Re: Title In listbox Properties

arulsettu — Thu, 23 Jan 2014 06:44:34 GMT

ya i know the data coming from the field. but the name of the list box where its coming frm?

Re: Title In listbox Properties

Thu, 23 Jan 2014 06:55:20 GMT

which demo app you using?

Re: Title In listbox Properties

arulsettu — Thu, 23 Jan 2014 06:59:17 GMT

Sales Management and Customer Analysis

Re: Title In listbox Properties

Thu, 23 Jan 2014 07:05:04 GMT

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

Re: Title In listbox Properties

Thu, 23 Jan 2014 07:08:49 GMT

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

Re: Title In listbox Properties

arulsettu — Thu, 23 Jan 2014 07:10:57 GMT

hi Shruthi

i checked the expression but there is no name

Re: Title In listbox Properties

Thu, 23 Jan 2014 07:14:15 GMT

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

Re: Title In listbox Properties

Thu, 23 Jan 2014 07:17:38 GMT

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

Re: Title In listbox Properties

arulsettu — Thu, 23 Jan 2014 07:18:14 GMT

ya it looks like this...

so the number holds the name?

Re: Title In listbox Properties

Thu, 23 Jan 2014 07:22:44 GMT

try it with if

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

Re: Title In listbox Properties

Thu, 23 Jan 2014 07:24:31 GMT

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