topic Reduce data in QlikView

Reduce data

marcohadiyanto — Sat, 15 Jan 2011 07:56:39 GMT

hi,

i have data in qvd, from 2000 to 2010, i want to get data from 2007 to 2010, how can make this happen?

i had try

Load

....

......

from data.qvd where year>2006

but only the date data type that were reduced and the other is like same before.

any suggestion.

thanks,

Marco

Sat, 15 Jan 2011 17:04:14 GMT

Hi Macro ,

I didnot understood your query . Please clarify the following ..

1) do u have only one qvd and when you are using the where condition, is the data not fetched according to the condition.

2) Do You have more than one QVD and you have to reduce the data in all the other Qvds based on the condition in the year table .

if you want o achieve the second query . you have to use the exists function on the key.

Regards,

Suman.

marcohadiyanto — Sat, 15 Jan 2011 17:25:48 GMT

hi, thanks for your reply.

i have more than one qvd.

i want to reduce only one qvd based on year condition.

example :

i have qvd from 2000 - 2010,

column : ID, Name, Date, Address

what i want is data from 2007-2010.

what should i do?

thanks

Sat, 15 Jan 2011 17:39:19 GMT

Hi Macro,

You can simply write a where condition where year(Date)>=2007. Hope this solves your issue . If not please eloborate your query.

Regards,

Chakravarthy.