topic Re: How to solve date issue? in QlikView

How to solve date issue?

Fri, 24 Aug 2012 06:22:29 GMT

Hi,

When I select DATE thru date listbox, it displays correctly. (see image below)

But when I select date thru Year, Month, Day, listboxes.. it displays nothing... (see image below)

Please help. I can't fix for now! I need experts working on dates.

Fri, 24 Aug 2012 06:29:51 GMT

have you created them from same source?

Ex Date field:

Year(Date) as Year,

Month(Date) as Month)

Day(month) as Day

Fri, 24 Aug 2012 06:32:16 GMT

Yes, I already have calendar for this.

nilesh_gangurde — Fri, 24 Aug 2012 06:36:08 GMT

Hi billiringer,

To get this work out First create the Master Calender table and link it to the base table with the "Date" Field.

Regards,

Nilesh Gangurde

Fri, 24 Aug 2012 06:40:02 GMT

I already have that, check the structure below

but still I have problem which I mentioned above!

renjithpl — Fri, 24 Aug 2012 06:41:59 GMT

=sum({<Date={"$(=max(Date))"}, Year=, Month=, Day=>} Sales)

you could try this..

Fri, 24 Aug 2012 06:44:53 GMT

Thanks renjthpl... Got it!

Fri, 24 Aug 2012 06:47:08 GMT

Got this, this is the answer

Thanks for the help!