Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
zfonline7888
Contributor II
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

May be this -

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

zfonline7888
Contributor II
Contributor II
Author

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

Digvijay_Singh

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

cengizeralp
Contributor III
Contributor III

this maybe solve

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

zfonline7888
Contributor II
Contributor II
Author

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

cengizeralp
Contributor III
Contributor III

Hi Mike,

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