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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.

0 Replies