Discussion Board for collaboration on QlikView Scripting.
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.