Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
zfonline7888
New Contributor II

Aggr in Expression question

Hi,

I have the following inline table:

load * inline

[

ID, Date, Status

1, 8/3/2018, Existing

2, 8/3/2018, New

3, 8/3/2018, Existing

4, 8/3/2018, New

5, 8/3/2018, New

6, 7/3/2018, Existing

7, 7/3/2018, New

8, 7/3/2018, New

]

;

Please help to create the following pivot table:

20180312a.PNG

I am using the following expression for Distribution:

count(aggr(Count(ID),Status,Date))/count(aggr(Count(total ID),Status,Date))

But get 100% in all values in Distribution.

Thank you very much.

6 Replies
Digvijay_Singh
Honored Contributor III

Re: Aggr in Expression question

May be this -

count(aggr(Count(ID),Status,Date))/count(total aggr(Count(total ID),Status,Date))

zfonline7888
New Contributor II

Re: Aggr in Expression question

Thank you for your reply, but your answer is not correct.

Digvijay_Singh
Honored Contributor III

Re: Aggr in Expression question

TRy removing outer count from numerator, else need to try with sample

cengizeralp
New Contributor III

Re: Aggr in Expression question

this maybe solve

count(ID) / count(total <Date> ID)

zfonline7888
New Contributor II

Re: Aggr in Expression question

No, you need use Aggr function to group the Date.  Thanks.

cengizeralp
New Contributor III

Re: Aggr in Expression question

Hi Mike,

Did you try it? Why do we need to use Aggr function?