topic Re: Master Calendar for Quarter, Week & Weekdays with year & Month Columns Only in QlikView

Master Calendar for Quarter, Week & Weekdays with year & Month Columns Only

bvssudhakar — Tue, 20 Mar 2018 13:17:33 GMT

Hi All,

I am new to qlikview

I have only Year & Month Columns in excel file like this :

Year

Month

Bank Name

ATMs Onsite

ATMs Offsite

POS Online

POS Offline

CREDITCARD Transactions Through ATMs (Millions)

CREDITCARD Transactions Through POS (Millions)

DEBITCARD Transactions Through ATMs (Millions)

DEBITCARD Transactions Through POS (Millions)

Months are in string format like : January, February,...

Now my requirement is: how can i show the "Quarters", "Weeks", "Weekdays" in my qlikview file this is an urgent requirement any default thing is there can any one explain me briefly and how can i show present/latest Quarter details defaulty

And i am using Desktop addition based on that help me

Thanks in Advance

Regards,

B V S Sudhakar

Re: Master Calendar for Quarter, Week & Weekdays with year & Month Columns Only

olivierrobin — Tue, 20 Mar 2018 13:28:13 GMT

hello

if you have only year and month, you can't do anything for weekd

for quarters, you have to transfer month names into month numbers (for example with a mapping load)

and then group values 01-04 to Q1, ...

Re: Master Calendar for Quarter, Week & Weekdays with year & Month Columns Only

sunny_talwar — Tue, 20 Mar 2018 13:31:53 GMT

I think you forgot to create %Date

Re: Master Calendar for Quarter, Week & Weekdays with year & Month Columns Only

bvssudhakar — Tue, 20 Mar 2018 14:08:58 GMT

Thank you very much Sunny

Now it is working Perfectly

Re: Master Calendar for Quarter, Week & Weekdays with year & Month Columns Only

bvssudhakar — Wed, 21 Mar 2018 11:26:05 GMT

Hi Sunny,

Thank you Sunny

and one more small query if we have date column how can we write the script.

Re: Master Calendar for Quarter, Week & Weekdays with year & Month Columns Only

sunny_talwar — Wed, 21 Mar 2018 11:29:36 GMT

Then you will not have to create a %Date here... you can just use your Date and find it's min and Max and then calendar table will also rename to Date instead of %Date