Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi! I have the following table:
Key | Entry |
---|---|
0 | x |
1 | x |
2 | x |
1 | y |
2 | y |
Now I want to create a visualization that contains the number of entries per Index as well as the number of entries for the previous index, so the result should look like this:
Key | Entries for Key | Entries for previous Key |
---|---|---|
0 | 1 | 0 |
1 | 2 | 1 |
2 | 2 | 2 |
The measure for the first measure I could easily define like this:
COUNT(ENTRY)
But I am having a very hard time expressing the second one. How would I express that measure?
This might have worked because the data was already sorted, try this and i think it won't work:
Load RecNo() as recno,* Inline [
Key ,Entry
0, x
2, x
1, x
1, y
2, y
];
You were right, actually, it's numericcount:
Aggr(Above(Count(Entry)), (Key,(NumericCount)))
Thank you MVP !
Not sure about NumericCount, but NUMERIC is def. there (https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/ChartFunctions/aggr.htm)
P.S. you can call me Sunny my friend
Ah, I didn't read your "Aggr" there first. That did the trick! Thanks a lot!
So for the record, I ended up using this expression:
Aggr(Above(Count(Entry)), Key)
Awesome
No numeric is showing to me:
Another thing Sunny, (I like to call you mvp by the way, coz you're so dedicated to help people in need, and I really appreciate it)
So, as I were saying, are familiar with security rules (qlik sense server)?
May be expression editor doesn't show it, I am sure NUMERIC will work. On the other hand, I am not sure if NUMERICCOUNT will work. Is it working for you? May be it is undocumented.
I have no idea about the security rules within Qlik Sense server