Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ziabobaz
Creator III
Creator III

PIVOT: difference and YearMTD column

Gents,

This is the relation to my previous topic, but in a more precise description

CYMTD vs PYMTD in one single measure

I want to build a PIVOT table to be able to compare number of measures between two periods. I am doing this is Excel now, but it's a pain.

Screenshot_1.png

There are two complications which I am trying to resolve in the last two days:

1. I am not able to build a difference column (amount and %)

2. I am not able to make a dimension which considers the interim period (MTD in my example): for example, if i choose March'17 against March'16, it shows FULL month in the second column and 8 days of the month in the first column (as of 8 of march 2017). 

Currently I was only able to build the following PIVOT table:

  • Measures as ROWS
  • Columns as [Year]+[Month]

Screenshot_39.jpg

Is that something that is possible to build in Qlik Sense? Maybe there is an extension which will help me to solve the problem?

Best regards,

Gleb.

2 Replies
ziabobaz
Creator III
Creator III
Author

Qlik Branch

KFTable extension - exactly what is needed, but not working with the latest version of QlikSense.

andyrea1000
Contributor
Contributor

Hi, where you able to solve this? i have the same issue, but cant work it out....

 

thanks

Andy