Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bitaneyim
Contributor

Autogenerate Dimensions with Variables

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

7 Replies
bitaneyim
Contributor

Re: Autogenerate Dimensions with Variables

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

Re: Autogenerate Dimensions with Variables

May be use ValueLoop:

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

bitaneyim
Contributor

Re: Autogenerate Dimensions with Variables

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

rgvavihs
Valued Contributor

Re: Autogenerate Dimensions with Variables

vVal1 :10

vVal2:30

vVal3:5

bitaneyim
Contributor

Re: Autogenerate Dimensions with Variables

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
Contributor II

Re: Autogenerate Dimensions with Variables

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

An Extreme Synthetic Dimension in QlikView

Re: Autogenerate Dimensions with Variables

What is the expression you are intending to use?

Community Browser