topic Re: Do not want aggreate value to compare in QlikView

Do not want aggreate value to compare

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

Hi All,

I have a requirement where

I have dimension called as strategy and has measure called as sum(sales).

Now i need to divide a strategy as long based on some condition like if( sum(revenue) >=0,sum(sales)) as newsales

I have different chart with new chart with dimension as owner and newsales as measure but i dont have strategy as dimention in this chart.

Now the newsales calculation is coming null as its getting aggregated but i want to only show the owner with strategy as long

Re: Do not want aggreate value to compare

jonathandienst — Wed, 17 Jan 2018 08:05:24 GMT

Do you want to group the calculation by strategy? Perhaps this:

Sum(Aggr(If(Sum(revenue) >= 0, Sum(sales)), strategy, owner))

[owner] is part of the Aggr() because it is the chart dimension.

Re: Do not want aggreate value to compare

zhadrakas — Wed, 17 Jan 2018 08:07:52 GMT

you can try an Expression like this

if(aggr(sum(revenue),YOURDIMENSION)>=0, sum(sales), '<0')

Re: Do not want aggreate value to compare

prashantsanchet — Wed, 17 Jan 2018 09:10:29 GMT

Hi ,

The requirement is like i have strategy dimension. I need to show the count of long strategy into KPI in qliksense

i need to classify the strategy into long and short based on

if ( sum(revenue) >=0 , then 'L' else short )

But the problem with this is sum(revenue) will give you only one value . But i want to compare each value of revenue based on strategy and classify them as short or long.

if(match(

if( aggr(sum([revenue]),strategy)

>=0,'L','S'),'L'),count(distinct([strategy])))

Please reply asap

Re: Do not want aggreate value to compare

zhadrakas — Wed, 17 Jan 2018 09:16:07 GMT

try like this

if(if(aggr(sum(revenue), strategy)>=0 'L', 'S')='L',count(distinct strategy), '#ELSE#')