topic Re: Issues with date in QlikView

Issues with date

anagharao — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I have a master calendar QVD (With 20 yrs of date) and i am trying to filter this according to the dates in Fact table. I'm using Keep to do so, and it works well.

However, I need the Month for an entire year displayed even if the Fact table does not have these dates.

I've attached an example below. The expected out come out be year as in fact but all months.

Regards,

Anagha

Re: Issues with date

jonas_rezende — Fri, 03 Jun 2016 13:59:41 GMT

Hi, Anagha Rao.

Instead of using LEFT KEEP, do association through the key field. Example:

FACT:

LOAD

Date as %Date,

Amount

FROM

\\svrin000mbp00.asia.corp.anz.com\umeshraa$\Desktop\Example.xlsx

(ooxml, embedded labels, table is Fact);

CALENDAR:

LOAD

Date as %Date,

Year,

Month

FROM

\\svrin000mbp00.asia.corp.anz.com\umeshraa$\Desktop\Example.xlsx

(ooxml, embedded labels, table is Calendar);

Hope this helps!

Re: Issues with date

anagharao — Tue, 21 Jun 2016 03:54:53 GMT

Thank you for the reply.

However this does not show all the months for a Financial year. I would like to see all months of a yr even if there are no data in the Fact table. I would also want the year to be as in the Fact table.