topic Re: multiple list box with dynamic load in QlikView

multiple list box with dynamic load

Anonymous — Wed, 02 Oct 2013 08:14:26 GMT

Hi,

I have a multiple list box (I'm sorry my version is in french I don't know what is the exact name in english):

So I have a list of dimensions, all selected manually in the object.

The problem is that my application is distributed for differents clients, and the dimensions of the list will change.

I don't want to make a different app for each client, so I'm searching for a solution to load from variables or a table these dimensions.

Is this possible?

Re: multiple list box with dynamic load

israrkhan — Wed, 02 Oct 2013 08:56:29 GMT

sorry , i could not understand you,and the object name is Multi box.

will you explain a bit more. you wrote " The Dimension of the list will Chang"?

Re: multiple list box with dynamic load

Anonymous — Wed, 02 Oct 2013 09:18:19 GMT

Ok,

Here I have a list of dimensions in my multi box:

CENTRE DE PROFIT, Commande SAP, etc.

But with another client this list will be modified (the data model is the same between EXCEPT this list of dimensions)

So, what I want is not having to specify each item of the multi box manually, but load dynamically a list of variables who contain the name of the dimension.

I'm sorry for my poor english, I hope you can understand.

Re: multiple list box with dynamic load

israrkhan — Wed, 02 Oct 2013 10:03:58 GMT

let me try with an example:

i think you can load and Concatenate new dimensions in the script:

but let say you have Country Dimension Table like

Country:

load * INLINE[

ID, Country

1, US

2, UK

3, SW

];

And Transaction Table

Sale:

load * INLINE[

Sale, Country

100, US

200, UK

300, SW

];

now you want to load some new dimensions in country table

you can do like below:

Concatenate (Country) load *INLINE [

ID, Country

4, YYY

5, XXX

];

Now Your Country Table will be like below:(new dimension are added)

1, US

2, UK

3, SW

4, YYY

5, XXX

as you said that only new dimension will be added, all others data model will remain same,

in that case your new dimensions YYY AND XXX will not have any linked data in transaction tables.

so they will not show any data, (are these new dimension does not seems useless)..

Re: multiple list box with dynamic load

qlikpahadi07 — Wed, 02 Oct 2013 11:11:55 GMT

Bonjour tdechiron

I think you need to give filters like my Dimensions A,B,C,D,E,F

A,B,C should be able see User1,

B,C,D User 2,

B,D,E,F User3

A,B,C,D,E,F User4

if this is a case yes you can but you have to provide a Section access

Google some Ideas about Qlikview Security/Section Access

cheers!!!

Re: multiple list box with dynamic load

Anonymous — Wed, 02 Oct 2013 12:14:07 GMT

Thanks to both of you, but it did not answer to my question.

What I wanted to know is how to load dimensions dynamically in the multibox, not in the script.