topic particular month and year data in QlikView

particular month and year data

vinod2086 — Wed, 28 Sep 2016 11:54:19 GMT

Hi frnds,

in my req i have a table that table contains more data but i need to display only feb 2015 to nov 2015. in script how to write condition

Thanks in advance

sunny_talwar — Wed, 28 Sep 2016 11:56:49 GMT

May be like this

Table:

LOAD ....

FROM ....

Where DateField >= MakeDate(2015, 2) and DateField <= MakeDate(2015, 11);

avinashelite — Wed, 28 Sep 2016 11:58:34 GMT

add a where condition like

LOAD * from table

WHERE Month_Year>='Feb 2015' and Month_Year<='Nov 2015';

NOTE: All the date format should be in the same format