topic Generate Sequential Numbers as a Calculated Dimension for a Line Chart in QlikView

Generate Sequential Numbers as a Calculated Dimension for a Line Chart

microwin88x — Tue, 24 Feb 2015 18:54:48 GMT

Hello,

I need to create a Line Chart where:

X Axis: Numbers from 1 to N (where N would be the quantity of values from a field)
Y Axis: Expression

So in my Line Chart I'd have in the X Axis:

(Expression)

...

50%

40%

30%

20%

10%

----- 1 2 3 4 5 6 7 8 9 10 (Calculated Dimension / Generated Sequential Numbers)

Is there any way to generate sequential numbers as a Calculated Dimension for a Line Chart?

Thank you!

Anonymous — Tue, 24 Feb 2015 19:12:01 GMT

What would your expression be and how would that relate to your desired Calculated Dimension ?

It may well be better to generate sequential numbers for your "Calculated Dimension" in the load script.

maxgro — Tue, 24 Feb 2015 19:29:46 GMT

to create a calculated (synthetic) dimension, you ca use

valueloop

example