Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've brought data from tables in SQL Server into QlikView. One of the tables is a set of responses to a questionnaire, the response can either be true or false. The problem I have is that some of the users have put multiple responses to a particular question - i.e. they have answered true, then changed their mind and answered false (and in some cases changed their mind again... and again).
So it could be the case that a certain question for a certain user has multiple responses, and I only want to consider the most recent response in QlikView.
Can anyone point me in the right direction of filtering this out in the QV app itself? I've been reading plenty on using QV to do this sort of task. I know I could sort the data out in SQL first but I think that's missing the point of QV - some help would be appreciated.
You can use FirstSortedValue function for that.
HI,
If u have datemodified column in your table then use the below statement while getting the data through sql statement.
sql select ID,Name,Response as RecentResponse,Datemodified
from TableName
where Datemodified=max(Datemodified);
I think that it may help u.
Regards,
Kabilan K.