topic Re: Ignore 2nd Dimension in QlikView

Ignore 2nd Dimension

dmac1971 — Fri, 15 May 2015 11:22:20 GMT

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?

Re: Ignore 2nd Dimension

Gysbert_Wassenaar — Fri, 15 May 2015 11:33:59 GMT

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

Re: Ignore 2nd Dimension

sunny_talwar — Fri, 15 May 2015 11:37:41 GMT

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