Adding Quarterly data on dashboard?

[#1]

To add a Year or a Month in the dashboard, I've added the following code in the Script:

Year ([Sl. No.]) as Year,
Month ([Sl. No.]) as Month

However, if i need to add Quaterly data, Q1, Q2, Q3 & Q4 in the dashboard, do we have a function/expression for it in QlikView?

Could you please help me out with this?

Thnks,

Hardik

[#2 · Accepted solution]

Hi Hardik!

Try:

'Q' & Ceil(Month([Sl. No.])/3) as Quarter

-Lester

[#3]

Hi Iprosete,

Aint working still after trying your expression...

[#4]

My bad, that worked perfectly! Thanks much 🙂

[#5]

Got all the Quarters in the dashboard, only that now its has Q1, Q2, Q3, Q4 & Q.

How do i remove 'Q' because upton selection of 'Q' my entire data goes off.