topic Re: variable expression explained in QlikView

variable expression explained

didierodayo — Thu, 06 Oct 2016 01:16:34 GMT

Hello ,

I am reviewing a qlik document and can't work out what this expression is doing.

IF(ONLY({$<device= {'Frizer'}>} [Sale value $(vL.SaleValue)] / Pricevariable) >= Pricevariable

only ({$<device= {'Frizer'}>}[Sale value $(vL.SaleValue)] / Pricevariable)

Question:

the expression work fine but what I don't understand is that there is no field in the called Sales value

there is a variable called $(vL.SaleValue)

why is the variable written is this format [Sale value $(vL.SaleValue)] inside the expression?

Thanks

Re: variable expression explained

sunny_talwar — Thu, 06 Oct 2016 01:29:57 GMT

There might be multiple fields in your dashboard which might start with Sale value, right? Like for instance:

Sale vale XYZ

Sale vale ABC

Sale vale DEF

...

It seems that the variable vL.SaleValue is dynamically switching between XYZ, ABC, and DEF field....

Re: variable expression explained

didierodayo — Thu, 06 Oct 2016 03:02:00 GMT

Yes Thanks Sunny, I just realised that is the case it is reading the value from those fields.

regards

Re: variable expression explained

didierodayo — Thu, 06 Oct 2016 03:14:18 GMT

HI Sunny, is it possible to define the expression better ? because at the moment even though it seems to work I can see it says [Expression Error] .

what we have in the dashboard is actually buttons 1- (Sale vale XYZ) 2- (Sale vale ABC) 3-(Sale vale DEF)

so when users click on the buttons it will sort by that.

could you suggest a different way of doing this because I have almost 15 expressions on different charts written in the same method.

Thanks

Re: variable expression explained

sunny_talwar — Thu, 06 Oct 2016 11:16:50 GMT

Expression Error can be ignored if the expression itself isn't giving you any trouble. I might only be able to give recommendations if I can see what exactly are you doing. Do you think you can share a sample ?