topic Re: Get amount by several distinct columns values in QlikView

Get amount by several distinct columns values

Thu, 28 Aug 2014 07:45:18 GMT

Hello!

I need some help. I have made an example table below, in this table I would like to get amount per Distinct Date, Distinct Group and Distinct Category. I can´t get it to work. For example for Date 2014-08-25 and Group A and Category C I would like to get 10 from the Amount column. Hopefully someone knows how to do it.

Date	Group	Category	Amount
2014-08-25	A	C	10
2014-08-25	A	C	10
2014-08-27	B	D	20
2014-08-27	B	D	20
2014-08-29	C	E	30

Best Regards

Mårten

Re: Get amount by several distinct columns values

ashfaq_haseeb — Thu, 28 Aug 2014 08:06:31 GMT

Hi,,

use below expression

=sum(aggr(sum(distinct Amount),Category,Group,Date))

Regards

ASHFAQ

Re: Get amount by several distinct columns values

Thu, 28 Aug 2014 08:14:09 GMT

Hi,

Take these Date, Category , group as 3 dimensions for the straight/pivot table

and use the expression as

sum(distinct Amount).

Re: Get amount by several distinct columns values

MK_QSL — Thu, 28 Aug 2014 08:29:56 GMT

Create a Straight Table

Dimension

Date

Group

Re: Get amount by several distinct columns values

Fri, 29 Aug 2014 06:32:49 GMT

Thank you all, now I get it correct.

Regards

Mårten