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

Thanks in Advance

Regards,

B V S Sudhakar

[sunny_talwar]

Uploading a Sample

[kakani87]

you can attach a file or document by selecting the use advanced editor option on right top

See the screen for reference

[Chanty4u]

open your thread in new window then you can able to see the option in reply with use advanced editor option

[bvssudhakar]

Hi Chanty

Thank you

and how to close the thread

[sunny_talwar]

Qlik Community Tip: Marking Replies as Correct or Helpful

[bvssudhakar]

Hi Niclas,

Thank you very much for giving the script. It is working perfectly

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