Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

multiple list box with dynamic load

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):

liste_multiple.jpg

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?

5 Replies
Highlighted
Specialist II
Specialist II

Re: multiple list box with dynamic load

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"?

Highlighted
Contributor III
Contributor III

Re: multiple list box with dynamic load

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.

Highlighted
Specialist II
Specialist II

Re: multiple list box with dynamic load

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)..

Highlighted
Specialist
Specialist

Re: multiple list box with dynamic load

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!!!

Highlighted
Contributor III
Contributor III

Re: multiple list box with dynamic load

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.