Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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:


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.