Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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
View solution in original post
Arul,
I do not get what you are talking about ,
well the expression uses the Set modifier for the No=9and call variable vDataLanguage
In the expression, they are using a variable: vDataLanguage.
Go to Settings and Variable Overview, you would find its value.
this img in title they calling variable right?
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.
hi itsangad,
the variable having some value so what is the use of this code?
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.
Where is to rest is set analysis and where is the Product Category name came from?
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.
ya i know the data coming from the field. but the name of the list box where its coming frm?
