topic Re: Expression in QlikView

Expression

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

Hi guys,

Not sure this is possible but I would like to sum the output of this expression

if(Sum([Suppliers FTL Cost]) + Sum([Suppliers Drop Cost]) > Sum([Cust FTL Cost]) + Sum([Cust Drop Cost]),1,0)

So basically if the output is 6 lines of 1 I want to see 6! This is needed for a KPI basically.

Is it possible?

Thanks

Re: Expression

sunny_talwar — Mon, 23 Apr 2018 14:11:18 GMT

May be use like this

Sum(Aggr(if(Sum([Suppliers FTL Cost]) + Sum([Suppliers Drop Cost]) > Sum([Cust FTL Cost]) + Sum([Cust Drop Cost]),1,0), DimensionsHere))

Use the dimension/s where you are evaluating this condition

Re: Expression

jamelmessaoud — Mon, 23 Apr 2018 14:23:05 GMT

Unfortunately that didn't work. Still not giving me the total overall

Re: Expression

jamelmessaoud — Mon, 23 Apr 2018 14:24:31 GMT

if I change the totals function to Sum from Auto this gives me the total which I need, so I was hoping there would be a way to "total" the expression that I have..

Wishful thinking i think!

Re: Expression

jamelmessaoud — Mon, 23 Apr 2018 14:38:59 GMT

Got it now.. Thanks for your help Sunny!

Re: Expression

sunny_talwar — Mon, 23 Apr 2018 14:39:51 GMT

Here is a good link from the help section.. this is for pivot table... but same is applicable in KPI object

http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/NestedAggregations/sum-of-rows…