Expressing measure the refers to values from different row of table

[Øystein_Kolsrud]

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?

[sunny_talwar]

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

];

[OmarBenSalem]

You were right, actually, it's numericcount:

Aggr(Above(Count(Entry)), (Key,(NumericCount)))

Thank you MVP !

[sunny_talwar]

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

[Øystein_Kolsrud]

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)

[sunny_talwar]

Awesome

[OmarBenSalem]

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)?

[sunny_talwar]

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