Date selection in Report

[anuradhaa]

Hi

i have created a report in qlikview and there i need three selection boxes as Year, Month and day. I have attached a image here.

There i have used List boxes and each list boxes i have set feild as expression and it is as"  =Year(MY_DATE_TIME) for year, =month(MY_DATE_TIME),day(MY_DATE_TIME) for day.

Then i have data for 2013/April/02 and may 02.

when i select 02 it shows data related to two months and it is ok.

but when i select April and then two it also shows above result. there April in green and march in white.

Please help me to solve this.

Thanks

[swuehl]

This indeed looks a bit strange.

Could you upload a small sample QV file, or the input data for MY_DATE_TIME you are using?

[anuradhaa]

Hi Please check attached xcl and qvw files

[kaushiknsolanki]

Dear Anuradha,

     It is functioning properly in the file you have uploaded.

     Kindly help us to replicate your issue in given qvw file.

Regards,

Kaushik Solanki

[anuradhaa]

Hi Thanks for your replies,

But my problem is still exist.

Think i want to see the data related to March 2nd. So please tell me how to do it?

How to select the data for march 2nd.

here when i select 2013 - > March -> and 2 it doesn't show expected result.

Hope you can understand my question.

Thanks

[kaushiknsolanki]

HI,

     Intead of creating the day and month in listbox with expression, calculate them in script only.

     like this.

LOAD

MY_DATE_TIME,

Year(MY_DATE_TIME) as Year,

Month(MY_DATE_TIME) as Month,

Day(MY_DATE_TIME) as Day

FROM

C:\Users\anuradha\Desktop\Qlikview\MY_DATE_TIME.xls

(biff, embedded labels, table is Sheet1$);

Regards,

Kaushik Solanki

[swuehl]

Yes, Kaushik Solanki is right.

If you are using expressions in your list boxes, you are actually selecting in field MY_DATE_TIME if you are selecting a Year, Month or Day. So all three boxes are bound to the same field.

If you select first Month, then Day, your Day selection will override Month, so you should get the same result when selecting only Day.

If you select Day 2, the month list box will show green for Apr, because there is only one possible value for this month, and this value is selected (Apr 2nd).

I think it will show white for Mar, because there are other MY_DATE_TIME values not selected (but IMHO also not possible). I agree this looks a bit confusing.

Best way around this is to use separate fields for Month, Day, Year, createed in the script, as suggested above (and this is also the recommended approach. You may also want to use a so called Master Calendar linked to the date part of your MY_DATE_TIME field, there are plenty of threads / blogs that cover that if you are interested in this).

Regards,

Stefan

[anuradhaa]

Yes, i will do that is script.

Thank you all for your support