Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tiklabaq
Creator
Creator

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
tiklabaq
Creator
Creator
Author

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
Creator
Creator
Author

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

Anonymous
Not applicable

vVal1 :10

vVal2:30

vVal3:5

tiklabaq
Creator
Creator
Author

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
Luminary Alumni
Luminary Alumni

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?