Autogenerate Dimensions with Variables

[tiklabaq]

Hi Community,

I want to create a calculated Dimension based von variables in a Inpout Box. I don't load data in this QVW, only with variables, which can be specified manually.

The calculated dimenson should be generated with this variables: vMin, vMax, vStep

e.g.

vMin=10000

vMax=25000

vStep=1000

Dimension
10000
11000
12000
13000
...
25000

[tiklabaq]

and of course I should be able to work with these values in the expression.

For example:

hourly wage (variable field in input box) * dimension

[sunny_talwar]

May be use ValueLoop:

ValueLoop($(vMin), $(vMax), $(vStep))

[tiklabaq]

thx, it works. and how can I use this values in the expression?

[Anonymous]

vVal1 :10

vVal2:30

vVal3:5

[tiklabaq]

ok I got it

You can use it in a dimension and if you use the same valueloop in the calculation you get the one value of this dimension line.

[gsbeaton]

I wrote a blog quite recently on a very similar topic which I think may help you:

An Extreme Synthetic Dimension in QlikView

[sunny_talwar]

What is the expression you are intending to use?