https://community.qlik.com/t5/QlikView/Build-calender-table-hierarchy-table-for-Quarter-snapshots/m-p/1505603#M598647 <P>Hi experts,</P><P>I have a set of data which only have the snapshots of every quarter end, a simplified one as below:</P><P>COMPANY_NAME,<BR />QUARTER,<BR />TYPE,<BR />#YTQ_ANP_USD,<BR />#YTQ_TOTAL_NOP,<BR />#CQ_ANP_USD,<BR />#CQ_TOTAL_NOP</P><P>I need to do some analysis on the figures e.g. Year to Year, Quarter to Quarter for specific quarter end.</P><P>Should I build a calendar table or a simple hierarchy table e.g. Year, quarter</P><P>Any tips is welcomed.</P> Wed, 14 Nov 2018 02:22:22 GMT yipchunyu 2018-11-14T02:22:22Z https://community.qlik.com/t5/QlikView/Build-calender-table-hierarchy-table-for-Quarter-snapshots/m-p/1505603#M598647 <P>Hi experts,</P><P>I have a set of data which only have the snapshots of every quarter end, a simplified one as below:</P><P>COMPANY_NAME,<BR />QUARTER,<BR />TYPE,<BR />#YTQ_ANP_USD,<BR />#YTQ_TOTAL_NOP,<BR />#CQ_ANP_USD,<BR />#CQ_TOTAL_NOP</P><P>I need to do some analysis on the figures e.g. Year to Year, Quarter to Quarter for specific quarter end.</P><P>Should I build a calendar table or a simple hierarchy table e.g. Year, quarter</P><P>Any tips is welcomed.</P> Wed, 14 Nov 2018 02:22:22 GMT https://community.qlik.com/t5/QlikView/Build-calender-table-hierarchy-table-for-Quarter-snapshots/m-p/1505603#M598647 yipchunyu 2018-11-14T02:22:22Z