topic AGGR & SUM in QlikView

AGGR & SUM

Fri, 17 Dec 2010 04:46:06 GMT

Hi,

I have a table with 2 dimensions > Customer & Product.

then i have one expression >>> if(sum(sales_last_month)=0,sum(sales_this_month))/1000

I'm trying to create a Text object to do the above but the result is not quite right.

=sum(aggr( if(sum(sales_last_month)=0, sales_this_month) , Customer ,Product))/1000

any ideas?
Thanks.

AGGR & SUM

deepakk — Fri, 17 Dec 2010 04:54:07 GMT

hi,

As per my understanding of Textobject, The textobject cant store array of value. Hence for your condition to work you have to select a Customer as well as Proudct.

I hope this helps.

AGGR & SUM

Fri, 17 Dec 2010 05:03:17 GMT

Hi Deepak ,

Thanks for the advice.

How about a table with no dimension. and we do everything in the expression? is it possible?

AGGR & SUM

deepakk — Fri, 17 Dec 2010 05:40:02 GMT

Hi,

In Pivot table it will show the value, but it will show the entire value.