topic Re: data reduce? in QlikView

data reduce?

Anonymous — Thu, 19 Mar 2015 07:28:40 GMT

i have

city:

bang

che

hyd

kerala and

area:

tinfactory

annasalai

hitechcity

ooty

sub area:

factory1

factory2

factory3

factory4

have data from last yer to till today

my req i want write a condition to show data for 'ooty' only nov 2014 onwards before nov 2014 want exclude ?

how ?

Re: data reduce?

PrashantSangle — Thu, 19 Mar 2015 07:45:46 GMT

Hi,

Acheive this in two steps;

step1:

Load all data excluding Area='ooty'

Step2:

Load Data only for Area='ooty' and Month Year>='Nov 2014'

and concatenate with table created in step1;

Regards

Re: data reduce?

Ralf-Narfeldt — Thu, 19 Mar 2015 07:51:39 GMT

I assume you have a date field in the data as well, let's call it dateField.

So you could add a condition at the end of your LOAD statement like:

WHERE area = 'ooty' AND dateField > Date('2014/11/30')

Of course you have to change dateField to your field name and adjust the date format to the format you use

Re: data reduce?

Anonymous — Thu, 19 Mar 2015 07:58:38 GMT

but i want exclude this date for only 'ooty' if i go this exclusion for other areas also dates will get excluded

Re: data reduce?

Ralf-Narfeldt — Thu, 19 Mar 2015 08:45:51 GMT

Ah, didn't understand you wanted the exclusion for ooty only. Just a small change:

WHERE NOT (area = 'ooty' AND dateField < Date('2014/12/01'))

Re: data reduce?

Anonymous — Thu, 19 Mar 2015 08:50:19 GMT

Go with max dreamer's suggestion.

That is the correct one

Let me know if you face any issues