Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
manas_bn
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Actuals, Forecast and Difference in pivot table

Did you try replacing  flag dimension with valuelist custom dimension ?

ValueList() – For those tricky situations

6 Replies
Employee
Employee

Re: Actuals, Forecast and Difference in pivot table

See attached for answer ...

Forecast.PNG

manas_bn
Contributor

Re: Actuals, Forecast and Difference in pivot table

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
Contributor

Re: Actuals, Forecast and Difference in pivot table

Any help, please..

Partner
Partner

Re: Actuals, Forecast and Difference in pivot table

Did you try replacing  flag dimension with valuelist custom dimension ?

ValueList() – For those tricky situations

manas_bn
Contributor

Re: Actuals, Forecast and Difference in pivot table

Works great! Thank you.

Partner
Partner

Re: Actuals, Forecast and Difference in pivot table

good to hear