Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
dilipranjith
Partner
Partner

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..

dilipranjith
Partner
Partner

Did you try replacing  flag dimension with valuelist custom dimension ?

ValueList() – For those tricky situations

View solution in original post

manas_bn
Creator
Creator
Author

Works great! Thank you.

dilipranjith
Partner
Partner

good to hear