topic Re: Set Expression - Subtraction using variable in QlikView

Set Expression - Subtraction using variable

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

Hi All,

I have below expression which is not giving me proper output. Here I ma selecting value based on the variable & Installed dimension value & displaying Status.

FirstSortedValue({< Total = {"<= $(Varible) - [Installed] "} >}[Upgrade Status,-[PathID])

Flow is -

Varibale value will be set from input box Variable = 20

Value for Installed = 15

So if everything works as expected and will get out put but I am not getting an expected output.

FirstSortedValue({< Total = {"<= 6 "} >}[Upgrade Status,-[PathID])

f i hard code value as 6 then i am getting output. is anyone able to help in this.

Re: Set Expression - Subtraction using variable

vishsaggi — Tue, 05 Jun 2018 21:23:51 GMT

try this

= FirstSortedValue({< [Upgrade Status] = {"$(= Total <= ((vVariable) - [Installed])) "} >} [Upgrade Status], -[PathID])

Re: Set Expression - Subtraction using variable

ashishbhuyekar — Wed, 06 Jun 2018 02:37:05 GMT

Vishwarath - This is not giving an expected result.

Re: Set Expression - Subtraction using variable

qliksus — Wed, 06 Jun 2018 02:54:33 GMT

Does the field Installed has more than one value? . why don't you try with some aggregation function like the below

FirstSortedValue({< Total = {"<= $(Varible) - max([Installed]) "} >}[Upgrade Status,-[PathID])

Re: Set Expression - Subtraction using variable

tamilarasu — Wed, 06 Jun 2018 03:03:22 GMT

Hi Ashish,

Try,

FirstSortedValue({< Total = {"<= $(=Varible - [Installed])"} >}[Upgrade Status,-[PathID])

Re: Set Expression - Subtraction using variable

sunny_talwar — Wed, 06 Jun 2018 11:54:53 GMT

Or this

FirstSortedValue({<Total = {"<=$(=$(Varible) - [Installed])"}>} [Upgrade Status,-[PathID])