Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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"?
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.
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)..
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!!!
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.