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

[bvssudhakar]

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

[olivierrobin]

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, ...

[sunny_talwar · Accepted solution]

I think you forgot to create %Date

[bvssudhakar]

Thank you very much Sunny

Now it is working Perfectly

[bvssudhakar]

Hi Sunny,

Thank you Sunny

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

[sunny_talwar]

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