topic Two dimensions at same level in QlikView

Two dimensions at same level

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Two dimensions at same level

Anil_Babu_Samineni — Mon, 25 Sep 2017 13:42:04 GMT

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

Re: Two dimensions at same level

Anonymous — Tue, 26 Sep 2017 10:33:43 GMT

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.

Re: Two dimensions at same level

Anonymous — Mon, 16 Oct 2017 13:15:07 GMT

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