Qlik Community

New to Qlik Sense

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

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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?