topic Re: Re: Last status per Source ID for random date selection in QlikView

Last status per Source ID for random date selection

Wed, 29 Jan 2014 10:13:49 GMT

I am trying to get the last status for each Source ID for a random date selection in the front end (by the users).

For e.g. original data set is as follows:

Now, if the user selects the date range from 03/01/2014 to 22/01/2014 then on Qlikview I want to show

MK_QSL — Wed, 29 Jan 2014 10:43:34 GMT

Check enclosed file.

Wed, 29 Jan 2014 14:01:47 GMT

Hi Manish

Thank you for the feedback.

One more thing, how do i get a count (collectively for all the statuses).

So assuming this was the result:

Source ID	FirstSortedValue(Status,-Date)	FirstSortedValue(Date,-Date)
x	A	25/01/2016
y	C	27/01/2017
z	B	29/01/2018
u	A	29/01/2018
v	A	27/01/2017
w	B	25/01/2016
s	B	29/01/2018
r	B	25/01/2016
t	C	27/01/2017

How do i get this:

FirstSortedValue(Status,-Date)	Count
A	3
C	2
B	4

MK_QSL — Wed, 29 Jan 2014 14:22:45 GMT

File enclosed.