Discussion board where members can get started with QlikView.
Currently I have a horizontal straight table like this:
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:
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.
Thanks in advance,
Go to Solution.
Did you try replacing flag dimension with valuelist custom dimension ?
ValueList() – For those tricky situations
See attached for answer ...
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.
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.
Any help, please..
Works great! Thank you.
good to hear