Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding Quarterly data on dashboard?

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi Hardik!

Try:

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

-Lester

View solution in original post

4 Replies
Not applicable
Author

Hi Hardik!

Try:

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

-Lester

Not applicable
Author

Hi Iprosete,

Aint working still after trying your expression...

Not applicable
Author

My bad, that worked perfectly! Thanks much 🙂

Not applicable
Author

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.