topic Qlikview Maximum dates comparison in QlikView

Qlikview Maximum dates comparison

muraliqlik — Fri, 04 Jan 2019 12:50:40 GMT

Hi Team,

below is the sample data for my requirement.

Title	Version	Date
abc	1	12/1/2018
abc	2	12/2/2018
abc	3	12/5/2018
abc	4	12/7/2018
abc	5	12/12/2018
def	1	1/1/2018
def	2	5/5/2018
def	3	7/7/2018
def	4	7/7/2018

I want to show only Titles whose final version Date and final minus one version Dates are not matching . for the above sample data my chart should like below. it should show only 'abc ' Title details as the dates are not matching for final version and final minus one version.

Title	Version	Date
abc	4	12/7/2018
abc	5	12/12/2018

Thanks

Murali

Re: Qlikview Maximum dates comparison

sunny_talwar — Fri, 04 Jan 2019 13:20:23 GMT

Try this expression

=If(Version >= Max(TOTAL <Title> Version, 2), Only({<Title = {"=FirstSortedValue(Date, -Version) <> FirstSortedValue(Date, -Version, 2)"}>}Date))

Re: Qlikview Maximum dates comparison

muraliqlik — Fri, 04 Jan 2019 14:04:43 GMT

Thank you so much Sunny . It is working perfectly except on one scenario.
if the either final version date or final minus one version date is null , in this scenario we shouldn't see the title.
I tried null handling by tweaking your expression, It is not working for me , could you please help

Re: Qlikview Maximum dates comparison

sunny_talwar — Fri, 04 Jan 2019 14:14:34 GMT

May be add a check for null as well

=If(Version >= Max(TOTAL <Title> Version, 2), Only({<Title = {"=FirstSortedValue(Date, -Version) <> FirstSortedValue(Date, -Version, 2) and Len(Trim(FirstSortedValue(Date, -Version))) > 0"}>}Date))