Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Latest dimension record in plain table

Hi all,

I need to show a table with just dimension values. Therefore I use a plain table with just dimensions, no expressions.

I wonder if it's possible to customizie the plain table thus, that just the latest VERSION for each STATUS is shown.

I know that this could handled by just loading thus records, but unfortunately they are needed othwerise.

Example attached.

Best regards

Thomas

1 Solution

Accepted Solutions
Nicole-Smith

Where you dimension is version, change it to a calculated dimension and use:

=aggr(maxstring(VERSION),TPLNR,DOKAR,DOSTX,STATUS)

Your fixed file is also attached.

View solution in original post

2 Replies
sujeetsingh
Master III
Master III

Try using calculated dimension for Version and then put in the logic to determine the latest one.

Nicole-Smith

Where you dimension is version, change it to a calculated dimension and use:

=aggr(maxstring(VERSION),TPLNR,DOKAR,DOSTX,STATUS)

Your fixed file is also attached.