Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
yipchunyu
Creator
Creator

Hierarchy / Calendar for quarter results

Hi expert, 

My data only have the snapshots for each quarter end e.g. 2017Q1, 2017Q2, 2017Q3 ...

I need to do some basic comparsion as quarter to quarter or year to year for specific month.

Should I build a hierarchy table or a calendar table for it?
Any tips?

7 Replies
pandiarajan
Creator
Creator

Hi,

Can u explain elaborate or can you explain with sample data?

Anil_Babu_Samineni

I think Calendar Table is enough for this question. If you really need hierarchy - How this works? 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MindaugasBacius
Partner
Partner

Could you provide data sample?

As comparison of months do not go along with quarterly information.

yipchunyu
Creator
Creator
Author

Thx all.  Attached is the workings data sample.

I may need to do comparsion e.g. 2018Q1 Vs 2017Q1 between the YTQ_TOTAL_NOP figures for Bank under Company A 

or 2018Q2 vs 2018Q1 of CQ_TOTAL_NOP.  

COMPANY_NAMETYPEQUARTERYTQ_TOTAL_NOPCQ_TOTAL_NOPYTQ_ANP_USDCQ_ANP_USDYTQ_ANP_HKDCQ_ANP_HKD
Company ABank2017Q12,5032,50335,35035,350275,729275,729
Company ABank2017Q25,0215,02173,47673,476573,112573,112
Company ABank2017Q37,7977,797115,379115,379899,959899,959
Company ABank2017Q49,8569,856145,849145,8491,137,6261,137,626
Company ABank2018Q11,5611,56139,37239,372307,101307,101
Company ABank2018Q23,0113,01179,58579,585620,762620,762
yipchunyu
Creator
Creator
Author

Any quick idea is welcomed. Thx
pandiarajan
Creator
Creator

Hi,
You can achieve this with calendar table and set analysis
yipchunyu
Creator
Creator
Author

So, better to add a date value on the fact table and then build a typical calendar table for use?