topic Re: Random value in QlikView

Random value

talita_verdes — Wed, 25 Nov 2020 16:16:04 GMT

Good afternoon!

I am not sure how to make a random value in a field.

For example:

If the field A = 2 then random between 1 and 10, if field A = 3 then random between 40 and 60.

I used it, but it did not work:

- Interval

- IntervalMach

- Rand

What can I do?

Thanks

vishsaggi — Wed, 12 Jul 2017 20:59:31 GMT

Quite did not get that. Can you explain a little with some sample data and expected output you are looking for?

sunny_talwar — Wed, 12 Jul 2017 22:50:11 GMT

May be like this

If(A = 2, Rand() * (10-1) + 1, If(A = 3, Rand() * (60-40) + 40)) as RandNum