Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

yipchunyu
New Contributor III

Build calender table / hierarchy table for Quarter snapshots?

Hi experts,

I have a set of data which only have the snapshots of every quarter end, a simplified one as below:

COMPANY_NAME,
QUARTER,
TYPE,
#YTQ_ANP_USD,
#YTQ_TOTAL_NOP,
#CQ_ANP_USD,
#CQ_TOTAL_NOP

I need to do some analysis on the figures e.g. Year to Year, Quarter to Quarter for specific quarter end.

Should I build a calendar table or a simple hierarchy table e.g. Year, quarter

Any tips is welcomed.