topic Re: conditional statement in graph expression in QlikView

conditional statement in graph expression

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

Hello,

I am trying to do get a margin but only if the price is >0 (we have some bad data)

I've tried a few things:

if(Sales_Price>0,
SUM(Sales_Unit_Price-Sales_Unit_Cost)/SUM(Sales_Unit_Price), 0)

Sum({<Quoted_Price={'>0'}>}),
Sum(Ave_Unit_Price-Ave_Unit_Cost)/SUM(Ave_Unit_Price))

Any Tips? I think I need Aggr in there maybe

Thanks!

olivierrobin — Tue, 17 Jul 2018 07:13:44 GMT

hello

and what about

sum(if(Sales_Price>0,Sales_Unit_Price-Sales_Unit_Cost))/sum(if(Sales_Price>0,Sales_Unit_Price))

laureadiaz — Tue, 17 Jul 2018 20:47:30 GMT

This seems to do the trick thanks!