topic Re: Aggr help in QlikView

Aggr help

dhanu_today — Fri, 14 Feb 2014 13:30:26 GMT

Hi Every one,

How we got the output as below.

Output:

Input Data:

Thanks,

Dhanu

luis_pimentel — Fri, 14 Feb 2014 13:33:46 GMT

You don't need de AGGR function. Use a table with type as dimension, and for the expressions:

POSITIVE: if (VALUE > 0 ,sum(VALUE))

NEGATIVE: if (VALUE < 0 ,sum(VALUE))

GROWTH: sum(VALUE)

hic — Fri, 14 Feb 2014 13:36:44 GMT

If your goal is to split up the "VALUE" in negative and positive numbers, you don't need any Aggr().

Sum( if(VALUE>0,VALUE) ) as POSITIVE

Sum( if(VALUE<0,VALUE) ) as NEGATIVE

Sum( VALUE ) as GROWTH

or the same with Set Analysis

Sum( {$<VALUE={">0"}>} VALUE ) as POSITIVE

Sum( {$<VALUE={"<0"}>} VALUE ) as NEGATIVE

Sum( VALUE ) as GROWTH

HIC

alexandros17 — Fri, 14 Feb 2014 13:38:51 GMT

Here it is ...

Hope it helps

MK_QSL — Fri, 14 Feb 2014 13:51:26 GMT

Like this..

ashwanin — Fri, 14 Feb 2014 14:03:57 GMT

HI Dhanu,

Use formula

Sum( {$<VALUE={">0"}>} VALUE) for +ve Values

Sum( {$<VALUE={"<0"}>} VALUE) for -ve Values

Sum( VALUE ) for growth.

Please find the qvw for same.

dhanu_today — Fri, 14 Feb 2014 17:09:14 GMT

Thanks all ...All are working...