topic Re: Multibox, Hide/Show field for several Customers in QlikView

Multibox, Hide/Show field for several Customers

marleygt — Wed, 01 Jul 2015 09:01:38 GMT

Hi all!

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.

Thank you!

Alex

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.

Re: Multibox, Hide/Show field for several Customers

Siva_Sankar — Wed, 01 Jul 2015 09:24:51 GMT

Alex,

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:

match(QVUser(), 'A','B','C').

Re: Multibox, Hide/Show field for several Customers

marleygt — Wed, 01 Jul 2015 09:39:21 GMT

Hi Shankarece!

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:

Section Access;

LOAD * INLINE [

ACCESS,USERID,PASSWORD,NTNAME,TYPE

ADMIN,ADMIN,,*,ADM

USER,*,*,QLIKSRVPRD\QVG_Customer1,AG

USER,*,*,QLIKSRVPRD\QVG_Customer2,AG

USER,*,*,QLIKSRVPRD\QVG_Customer3,AG

USER,*,*,QLIKSRVPRD\QVG_Customer4,AG

USER,*,*,QLIKSRVPRD\QVG_Customer5,AG

USER,*,*,$(vUser_00),AG

USER,*,*,$(vUser_01),AG

USER,*,*,$(vUser_02),AG

USER,*,*,$(vUser_03),AG

USER,*,*,$(vUser_04),AG

USER,*,*,$(vUser_05),AG

];

Section Application;

How it should be in the Layout Expression?

i.e. match(QVUser(),'QVG_Customer1')

Thank you!

Re: Multibox, Hide/Show field for several Customers

Siva_Sankar — Wed, 01 Jul 2015 09:46:54 GMT

Alex,

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

Re: Multibox, Hide/Show field for several Customers

Siva_Sankar — Wed, 01 Jul 2015 09:47:59 GMT

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.

Re: Multibox, Hide/Show field for several Customers

marleygt — Wed, 01 Jul 2015 09:51:49 GMT

OOOK! Got it!

Let me try.

I am coming back later for any doubt..just in case!

Thank you again.

Re: Multibox, Hide/Show field for several Customers

Siva_Sankar — Wed, 01 Jul 2015 09:53:22 GMT

sure.

Re: Multibox, Hide/Show field for several Customers

stigchel — Wed, 01 Jul 2015 10:13:47 GMT

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

Example attached

Re: Multibox, Hide/Show field for several Customers

marleygt — Wed, 01 Jul 2015 11:04:59 GMT

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!