topic Re: How to write this expression in QlikView

How to write this expression

Thu, 27 Oct 2016 08:01:46 GMT

Hi All,

I have those data:

load * Inline

[DayDate,Cohort,MemberId

2013-1-1,1,1

2013-1-1,1,2

2013-1-1,2,1

2013-1-1,2,2

]

;

And I am using pivot table to show the active MemberId by DayDate by Cohort

The result will be

DayDate, Cohort, ActiveMembers

2013-1-1, 1, 2

2013-1-1,2, 2

For the ActiveMembers, I use count(distinct MemberId), What I want is add one more column to show the total ActiveMembers by DayDate by Cohort. that is 4

DayDate, Cohort, ActiveMembers

2013-1-1, 1, 2

2013-1-1,2, 2

Total: 4

What Shall I do?

Thanks.

Re: How to write this expression

zhadrakas — Thu, 27 Oct 2016 08:14:01 GMT

hello,

is this what you want?

regards

Re: How to write this expression

johanlindell — Thu, 27 Oct 2016 08:49:03 GMT

Make a sub-total for the "DayDate" column and make an Aggregate expression on the dimensions you want to aggregate by.