topic Filtering out unwanted data in QV in QlikView

Filtering out unwanted data in QV

Wed, 29 Aug 2012 15:24:31 GMT

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.

Re: Filtering out unwanted data in QV

whiteline — Sat, 01 Sep 2012 18:01:12 GMT

You can use FirstSortedValue function for that.

Re: Filtering out unwanted data in QV

Mon, 03 Sep 2012 11:48:31 GMT

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.