topic Re: Values as Variable in QlikView

Values as Variable

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

at the moment i have some formula where Item_Category are listed as below.

Because I have like 10 formula like this, in case in the future i will have to change the item category i will need to change 10 rules which is not so efficient.

I would like to map as variable the list of the category, and then enter in the formula the variable like Item_Category=Variable Name.

Is something possible? and which is the correct syntax for variable mapping and expression ?

Thank you!!

Re: Values as Variable

sunny_talwar — Mon, 19 Jun 2017 12:58:42 GMT

You can do that... just grab the list of Item_Category and throw them in a variable

vItem

'FRT', 'IMP', 'IMPU', 'SCN', 'SMP'

and then your set analysis

Item_Category = {$(vItem)}

Re: Values as Variable

MK_QSL — Mon, 19 Jun 2017 13:01:10 GMT

Create a Variable

vItemCategory

Item_Category = {'FRI','IMP','IMPU','SCN','SMP'}

Now use

SUM({<Area -= {'Area-not-available'},$(vItemCategory)>}ExtendedUSD)

Ignore red lines...