Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manas_bn
Creator
Creator

Actuals, Forecast and Difference in pivot table

Hello all!

Currently I have a horizontal straight table like this:

Horizontal St Table.PNG

I need to create a table which is similar to the above, but it should have actuals, forecast and difference for each of the metric.

Something like this:

Excel.PNG

I tried creating a flag for Actuals and Forecast, but I am not able to create "Delta" for each of the metric. I have attached a sample for anyone who wants to help.
Pivot with flag.PNG

Thanks in advance,

Manas

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Did you try replacing  flag dimension with valuelist custom dimension ?

ValueList() – For those tricky situations

View solution in original post

6 Replies
Lisa_P
Employee
Employee

See attached for answer ...

Forecast.PNG

manas_bn
Creator
Creator
Author

Thanks Lisa, unfortunately this is not what I was looking for.

Both "Metric" and "Count" are 2 different measures. I need the Table to show like this, but also with the delta next to actual and forecast.

Pivot with flag.PNG

Consider Metric 1 to be Call Count and Metric 2 to be Membership Count. For each of these, I will need to show Actual, Forecast and Delta. Actual and Forecast is easy to show this way, but not Delta.

manas_bn
Creator
Creator
Author

Any help, please..

dplr-rn
Partner - Master III
Partner - Master III

Did you try replacing  flag dimension with valuelist custom dimension ?

ValueList() – For those tricky situations

manas_bn
Creator
Creator
Author

Works great! Thank you.

dplr-rn
Partner - Master III
Partner - Master III

good to hear