Discussion Board for collaboration on QlikView Layout & Visualizations.
Here I am again with another question about Hide and Show, this time it's a Multibox and as usual, with a more complex scenario.
Let's say I have 3 (or more) customers and they are sharing same Qlikview Application.
They have same business but different area of interest.
In this example I have a Multibox with a total of 6 fields; some of them are commons to all, others not.
Which solution you could apply for the best (light) and fast result, knowing that in the next future, customers could ask for join less or more fields?
A sample is attached.
Ps: I've already implemented a solution, at the moment 2 different Multibox with Variable for hide/show...but is just a tricky way and I think is not the right solution in the moment customers will becomes more then half-a-score.
My suggestion is use OSUser() or QVUser(() function in the layout condition.
Create 3 different multibox with layout condition to match the user name
For example, you want a object to be visible only for users A, B, and C. In this case, enter this in Show condition:
Thank you for fast reply.
The idea sounds good;
May I ask you just another thing, as I never use before this way;
My Section Access looks like:
LOAD * INLINE [
How it should be in the Layout Expression?
No need of section access for this object level section access.
Create three multibox with different fields. for user 1, if you want to show all the fields..something like below screenshot
Do similarly for all the other customers for the different multiboxes. So the qvw file detech the user name and it is matched it will show the object else it will not show.
You could also use section access to load a list of fields to be included in the filter multiboxes. Then add as many multiboxes as there are max nr of filters. Make each mb variable (first field of fields, second....), so using a variable field. The only thing you have to maintain is when the max nr of filters changes and offcourse the user list
hey Piet Hein! Thank you! Looks Brillant!
I am trying both solution (on real project) and it takes a little bit...
I will let you know something.
Thank you again!