This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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:
I am using the following expression for Distribution:
But get 100% in all values in Distribution.
Thank you very much.
May be this -
count(aggr(Count(ID),Status,Date))/count(total aggr(Count(total ID),Status,Date))
Thank you for your reply, but your answer is not correct.
TRy removing outer count from numerator, else need to try with sample
this maybe solve
count(ID) / count(total <Date> ID)
No, you need use Aggr function to group the Date. Thanks.
Did you try it? Why do we need to use Aggr function?