topic Re: I should display the data by month wise in QlikView

I should display the data by month wise

Anonymous — Thu, 24 Jul 2014 11:09:43 GMT

HI All,

To display the data's by month wise for example Jan Feb Mar i have data only for month Feb month and the field with Date and time when i select Feb month i should display the data's for the Feb month. Can any one help on this.

Thanks & Regards,

sivakumar

Re: I should display the data by month wise

ashfaq_haseeb — Thu, 24 Jul 2014 11:13:31 GMT

Try below in load script.

Load Field1,

Field2,

DateTimeField,

Date(Floor(DateTimeField)) as Date,

Month(DateTimeField) as Month

from table

Now use month in your front end to filter

Regards

ASHFAQ

Re: I should display the data by month wise

Thu, 24 Jul 2014 11:16:50 GMT

Hi sivakumar,

From your Date&Time Field work like this,

If it is text format,

Load

month(floor(date(date#(YourDate&TimeField,'DD-MM-YYYY hh:mm:ss') ,'DD-MM-YYYY'))) as Month

From source;