topic How to use variable in set expression ? in QlikView

How to use variable in set expression ?

Wed, 15 Jun 2011 09:19:41 GMT

Hi,

I have a doubt which seems very basic but I am unable to find the solution.

I have a field named 'Product' with values 'CITY', 'Civic', 'Jazz' etc

If I set the expression,

Sum({<Product={'CITY'}>}sum) ... I get the CITY specific chart. But I want to make the chart dynamic based on the 'Product' selection made by the user....

So I have set a variable named 'ProVar' which will have its correspoding 'Product' value assigned as user selects from a product list box.

I need to edit the expression so that it will take the ProVar and change Dynamicaly.

When I modify the expression like this Sum({<Product={ProVar}>}sum) its not working.

I know that it shud be a simple issue.. but it'll be of great help if you can just let me know the correct syntax for framing in the set expression in this case.

How to use variable in set expression ?

Wed, 15 Jun 2011 09:25:25 GMT

sum({<Product=${ProVar}>})

use this may it helps u.

Regards,

Chandra

How to use variable in set expression ?

Wed, 15 Jun 2011 09:26:02 GMT

I tried using Sum({<Product={'$ProVar'}>} sum) .. but still this is not working..

Re: How to use variable in set expression ?

Wed, 15 Jun 2011 09:27:07 GMT

Hi,

sum({<Product=${ProVar}>})

use this may it helps u.

Regards,

Chandra

Re: How to use variable in set expression ?

perumal_41 — Wed, 15 Jun 2011 09:28:55 GMT

Sum({<Product={$(ProVar)}>}sum).please try this

Re: How to use variable in set expression ?

Wed, 15 Jun 2011 09:28:58 GMT

Hi,

sum({<Product=$(ProVar)>})

hey sorry for the previous post , i for got to use braces

Regards,

Chandra

How to use variable in set expression ?

brenner_martina — Wed, 15 Jun 2011 09:29:20 GMT

Hi,

you have to enter:

Sum({<Product={$(=Only(Product))}>} Fieldname)

or if you want to use a variable, define one at Settings:

varProduct =Product

Sum({<Product={$(varProduct)}>} Fieldname)

How to use variable in set expression ?

pat_agen — Wed, 15 Jun 2011 09:33:18 GMT

hi,

it will be easier to help if you post the definition of your variable ProVar. Depending how this is set will shwo you hwo the varaible shoudl be dealt with.

For a start $ expansion requires that the varaibel to be expanded is found inside the brackets like this $(ProVar).

However thsi may react differently depending on what ProVar contains.

start by replacing

Sum({<Product={'$ProVar'}>} sum)

with

Sum( { <Product= {$(ProVar)}>} sum)

see what happens. If no luck post teh definition of your variable

How to use variable in set expression ?

Wed, 15 Jun 2011 09:40:12 GMT

This worked fine for me

Sum({<'$ProVar'>} sum)

Thanks a lot for your replies