Discussion Board for collaboration related to Creating Analytics for QlikView.
I'd like to retrieve the latest text field for each specific type of values.
Well the latest comment for R_AMO is Fruit, but the latest comment for R_SSG is Vegetable. Not that the latest date for R_AMO is 2015-07-15 but is 2017-07-16 for R_SSG.
I've got this down as an expression for my dimension "Comment" in a chart.
= if(match(Date, '$(=Max(Date))'), Comment, 'nay')
All I get are Nays
Any ideas on this?
Go to Solution.
=If(Date = Aggr(NODISTINCT Date(Max(Total <Rule> Date)), Rule), Comment, 'nay')
Try this as your calculated dimension:
= if(match(Date, '$(=Date(Max(Date)))'), Comment, 'nay')
R_AMO is still at nay because the Max date for the entire set is 2015-07-16... but R_AMO's maxdate is 2015-07-15...
Helpfull though thanks
Got it, working on it now
that's a winner right there.
Glad I was able to help.