Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
yipchunyu
Creator
Creator

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.

Labels (1)
0 Replies