topic How to get possible values from the script in QlikView

How to get possible values from the script

slondono — Tue, 05 Jul 2016 21:18:58 GMT

Hi guys.

I have an excel with 2 fields, something like this:

Region SubRegion

1 10

1 12

1 8

2 6

2 2

3 5

3 20

I need a way from script, to get the subregions. I mean something like this

vRegion1 = "10,12,8"

Any idea?

vikramv — Tue, 05 Jul 2016 21:39:34 GMT

Try this.....

===================

Tab1:

Load * Inline

[

Region, SubRegion

1 , 10

1 , 12

1 , 8

2 , 6

2 , 2

3 , 5

3 , 20

];

Tab2:

NoConcatenate

Load Region , Concat(SubRegion , ',') as vRegion1 Resident Tab1 Group by Region;

Drop Table Tab1;

sunny_talwar — Tue, 05 Jul 2016 21:39:43 GMT

May be something like this:

LOAD Region,

Concat(Sub-Region, ', ') as ConcatList

Resident Table

Where Region = 1;

Let vRegion1 = Peek('ConcatList');