topic Re: Chart with value changes, is it possible? in QlikView

Chart with value changes, is it possible?

dapostolopoylos — Thu, 09 Nov 2017 16:24:20 GMT

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?

Re: Chart with value changes, is it possible?

Peter_Cammaert — Thu, 09 Nov 2017 16:44:35 GMT

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()

Re: Chart with value changes, is it possible?

dapostolopoylos — Fri, 10 Nov 2017 09:40:01 GMT

That's it!

Thank you very much!