Discussion Board for collaboration related to QlikView App Development.
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?
'Q' & Ceil(Month([Sl. No.])/3) as Quarter
View solution in original post
Aint working still after trying your expression...
My bad, that worked perfectly! Thanks much 🙂
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.