topic Re: QlikView User Interface in QlikView

QlikView User Interface

Anonymous — Sat, 12 Dec 2015 08:01:45 GMT

I have an application with a lot of tabs and the appearance is becoming cluttered and non professional. My current tabs look as follows:

Some of them will not be available to some users through section access which i have already implemented. I was checking on the best way to remove the clutterness and remain with a clean user interface. I have realised that you can hide tab rows and one option was to use linked text objects with an ActivateSheet action for the user interface on each sheet. My problem with this is that it is not very different from the current multiple tab rows as i will be introducing multiple linked text objects on each sheet. Is there a way to build a drop down menu to select/activate sheets and in this way, that will minimise the addition of multiple unnecessary text objects?

Regards.

Re: QlikView User Interface

ecolomer — Sat, 12 Dec 2015 09:09:17 GMT

You need use SECTION ACCESS to identify users and each tabs put in conditional mode

See this:

Introduction to Section Access

Re: QlikView User Interface

ecolomer — Sat, 12 Dec 2015 09:11:24 GMT

see this example

Re: QlikView User Interface

Anonymous — Sat, 12 Dec 2015 09:33:56 GMT

Thanks Enrique, i have implemented section access for user with rights for the sheets. What i am looking at is a user interface with no tabrows.

Regards

Re: QlikView User Interface

ecolomer — Sat, 12 Dec 2015 09:55:17 GMT

Select tabs to see each user in the conditional option

Re: QlikView User Interface

ecolomer — Sat, 12 Dec 2015 09:57:21 GMT

See this:

QlikView Section Access Examples

Re: QlikView User Interface

marcus_sommer — Sat, 12 Dec 2015 10:01:10 GMT

By using the AJAX client could be this an alternative:

dropdown menu extension

Pure Drawer Menu

If this is not suitable you need to disable the tab-rows and navigate with button, listboxes and/or table-charts which clicking/selecting changed variable-values for visibilty for each of your sheets. But by so many sheets it will need some efforts to create a "nice" solution - a first step could be to group these sheets into categories which could be hidden or visible with one click/action:

Handling many tabs in QlikView.pdf

QlikView App - Show and Hide Sheets based on User or Menu

- Marcus

Re: QlikView User Interface

Anonymous — Sat, 12 Dec 2015 10:20:04 GMT

Maybe have look a reducing the number of tabs by consolidating some of them.

You have 5 tabs whose names start with "Leading". How about having one "Leaders" tab and have objects on this tab hidden / shown by buttons. I routinely use this technique. If you make objects to be hidden / shown exactly the same size / position then transitions between them become graceful.

Re: QlikView User Interface

Anonymous — Sat, 12 Dec 2015 11:14:55 GMT

Thanks Marcus for your valuable input i will look into the references

Re: QlikView User Interface

Anonymous — Sat, 12 Dec 2015 11:15:34 GMT

Thanks Bill will look at your recommendations

Re: QlikView User Interface

Anonymous — Sun, 13 Dec 2015 09:10:03 GMT

Hi Marcus

The article 'Handling many tabs in QlkView is an excellent reference for what i am looking for. I have used this for the multibox solution with the following inline load for the tabrows:

View:
LOAD * Inline [
View
Dashboard
Point in Time Reporting
Leading Therapeutic Classes (Level 1)
Leading Therapeutic Classes (Level 3)
Leading Companies
Leading Products
Leading New Products
Payment Method Summary
Co-payment Summary
Fastest Growing Therapeutic Classess (ATC3)
Trend Analysis
Product Analytics
Generic Products Opportunity Analysis
Patent Analytics
FDA Analytics
Shopping Analytics
Pharmacy Analytics
];

I then assigned the field View to a multi box with the following results:

How do i configure the application to respond to the selections in the multibox?

Regards

Re: QlikView User Interface

marcus_sommer — Sun, 13 Dec 2015 10:52:20 GMT

In this case you used a visibility-condition (sheet properties in tab general in top left) with a query on the selection from this field, for example for the sheet Dashboard:

= if(getfieldselections(View) = 'Dashboard', true(), false())

and then copy+paste this expression in the another sheets and adjust the sheetname. Helpful is further to extend this to another condition - per variable - to be able to see (if wanted) all sheets:

= if(getfieldselections(View) = 'Dashboard', true(), false()) or $(vAdminView) = 1

- Marcus

Re: QlikView User Interface

Anonymous — Sun, 13 Dec 2015 13:08:35 GMT

Hi Marcus

Thank you very much, what i was looking for

Regards.

Chris