Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rohitk1609
Valued Contributor II

Parent Column Name in Pivot table

Hi Techies,

I have a pivot table which has one dimension and 5 calculated measure which has label with variables. The pivot look like:

                   Measures

Brand  Cal1,Cal2 Cal3 Cal4 Cal5

A

B
C

D

My requirement is :

                   Measures

               MTD               YTD

           Cal1,Cal2 Cal3 Cal4 Cal5

Brand 

A

B
C

D

I want to put MTD for Cal1 and Cal2 then YTD for Cal3, Cal4, Cal5.

Please guide me how to do it, Do i need to add one more dimension with MTD and YTD values or something else ?

Best

Rohit

Community Browser