Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
marleygt
Contributor

Multibox, Hide/Show field for several Customers

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.

8 Replies
Siva_Sankar
Honored Contributor

Re: Multibox, Hide/Show field for several Customers

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

marleygt
Contributor

Re: Multibox, Hide/Show field for several Customers

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!

Siva_Sankar
Honored Contributor

Re: Multibox, Hide/Show field for several Customers

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

Siva_Sankar
Honored Contributor

Re: Multibox, Hide/Show field for several Customers

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.

marleygt
Contributor

Re: Multibox, Hide/Show field for several Customers

OOOK! Got it!

Let me try.

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

Thank you again.

Siva_Sankar
Honored Contributor

Re: Multibox, Hide/Show field for several Customers

sure.

Partner
Partner

Re: Multibox, Hide/Show field for several Customers

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

marleygt
Contributor

Re: Multibox, Hide/Show field for several Customers

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!