topic Pick random value for a dimension in QlikView

Pick random value for a dimension

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

Hi Experts,

I have table data as below

Number Description

1 Description1

1 Description2

1 Description3

2 Description21

3 Description31

4 Description32

Expected Result - to pick any one of the description against the number

Number Description

1 Description1

2 Description21

3 Description32

Can we use below expression ?

=AGGR(Pick(1, [Description]),Number)

Thanks

vishsaggi — Mon, 13 Aug 2018 20:47:14 GMT

may be try this?

Random:

LOAD *

Where RandNum = 1;

LOAD *,

Number&Description AS NumDesc,

AutoNumber(Number&Description, Number) As RandNum INLINE [

Number, Description

1, Description1

1, Description2

1, Description3

2, Description21

3, Description31

4, Description32

];

tamilarasu — Tue, 14 Aug 2018 02:07:49 GMT

If you really want to use calculated dimension then try,

=AGGR(FirstSortedValue(Distinct [Description],Number),Number)

fabdulazeez — Tue, 14 Aug 2018 04:20:22 GMT

Create a Table Chart

Dimension : Number

Measure : MaxString(Description)