Chart with value changes, is it possible?

[dapostolopoylos]

Hello, Qlikers.

I have to visualize the changes of some measures in a very certain way, i was given an Excel template that looks somewhat like this:

	Actual	Budget	Diff	Diff %	Actual YTD	Budget YTD	Diff YTD	Diff % YTD
Sold Qty (in PCs)
Sold Qty (SU)
Gross Revenue
Reconciliations
Net Revenue

The chart will be populated only for the reference Month.

Do you have any idea how we could create such a chart?

[Peter_Cammaert · Accepted solution]

Yes.

Because the first column displays artificial Dimension Values (e.g. metrics names), you may want to use a Calculated dimension with a call to ValueList(), and a nested IF() using 5 different expressions for each column.

See for example the ValueList() example in Robert Mika's Missing Manual treatment: Missing Manual - ValueLoop() & ValueList()

[dapostolopoylos]

That's it!

Thank you very much!