topic Adding Quarterly data on dashboard? in QlikView https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265145#M1204576 <HTML><HEAD></HEAD><BODY><P>My bad, that worked perfectly! Thanks much <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 13 Jul 2010 11:42:42 GMT 2010-07-13T11:42:42Z Adding Quarterly data on dashboard? https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265142#M1204573 <HTML><HEAD></HEAD><BODY><P></P><P>To add a Year or a Month in the dashboard, I've added the following code in the Script:</P><P>Year ([Sl. No.]) as Year,<BR />Month ([Sl. No.]) as Month</P><P>However, if i need to add Quaterly data, Q1, Q2, Q3 &amp; Q4 in the dashboard, do we have a function/expression for it in QlikView?</P><P>Could you please help me out with this?</P><P></P><P></P><P>Thnks,</P><P>Hardik</P></BODY></HTML> Tue, 13 Jul 2010 06:42:32 GMT https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265142#M1204573 2010-07-13T06:42:32Z Adding Quarterly data on dashboard? https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265143#M1204574 <HTML><HEAD></HEAD><BODY><P>Hi Hardik!</P><P>Try:</P><P></P><P>'Q' &amp; Ceil(Month([Sl. No.])/3) as Quarter</P><P></P><P>-Lester</P><P></P></BODY></HTML> Tue, 13 Jul 2010 06:53:10 GMT https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265143#M1204574 2010-07-13T06:53:10Z Adding Quarterly data on dashboard? https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265144#M1204575 <HTML><HEAD></HEAD><BODY><P>Hi Iprosete,</P><P>Aint working still after trying your expression...</P></BODY></HTML> Tue, 13 Jul 2010 07:39:46 GMT https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265144#M1204575 2010-07-13T07:39:46Z Adding Quarterly data on dashboard? https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265145#M1204576 <HTML><HEAD></HEAD><BODY><P>My bad, that worked perfectly! Thanks much <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 13 Jul 2010 11:42:42 GMT https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265145#M1204576 2010-07-13T11:42:42Z Adding Quarterly data on dashboard? https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265146#M1204577 <HTML><HEAD></HEAD><BODY><P>Got all the Quarters in the dashboard, only that now its has Q1, Q2, Q3, Q4 &amp; Q.</P><P>How do i remove 'Q' because upton selection of 'Q' my entire data goes off.</P></BODY></HTML> Tue, 13 Jul 2010 11:53:18 GMT https://community.qlik.com/t5/QlikView/Adding-Quarterly-data-on-dashboard/m-p/265146#M1204577 2010-07-13T11:53:18Z