Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
dmac1971
Creator III
Creator III

Ignore 2nd Dimension

Lets say I have a Straight Table showing Item No, Desc and then YOY Sales and change.  The item number will never change but sometimes the description will.  This means showing YOY doesn't work so well if the desc have changed from one year to the next.  I've tried using the TOTAL function and this works but then shows the same item and desc twice.  All I want is to show the item once, then the most recent description ?  Is this possible?

2 Replies
Gysbert_Wassenaar

Try an expression to get the description of the latest year: FirstSortedValue( Desc, -YearFieldHere)


talk is cheap, supply exceeds demand
sunny_talwar

Instead of using description as a dimension, use it in expression with FirstSortedValue() function:

=FirstSortedValue(Description, -SomeKindOfCounter) (Counter can be a date)

HTH

Best,

Sunny