Two dimensions at same level - Qlik Community

Anonymous · ‎2017-09-22

I need to replicate this table chart in which:

- the 4th first columns are the quarters of the past Year

-the 3 next columns are the month of the actual Quarter

-finally the actual Quarter

-(the Target Q is not needed)

I am unable to this. I can not put the actual quarter as it involves the month columns.

Anil_Babu_Samineni · ‎2017-09-25

If possible please create bucket and then use that dimension bucket to achieve this

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-09-26

First of all, thanks for answering.

Sadly that does not works (or i can't come with the rigth formula) as the Quarter includes the 3 months.

Anonymous · ‎2017-10-16

Just for the record. This is not possible :/. The only thing one can do is duplicate the tableso you can take the months and then the quarters. Another way is creating to tables (less memory demanding).

#Qlikisdarkandfulloftricks