topic Re: Global KPI bar in QlikView

Global KPI bar

Wed, 25 Nov 2020 16:16:04 GMT

I am working on a dashboard which has several sheets, and I need to display same group of KPI objects in some sheets. Instead of copy & paste linked KPI object in sheet one by one, is it possible to create a global KPI bar, so these sheets can share the global KPI bar?

Thank you!

Re: Global KPI bar

trdandamudi — Wed, 17 May 2017 18:08:54 GMT

As far as my knowledge it is not possible...

Re: Global KPI bar

Anil_Babu_Samineni — Wed, 17 May 2017 18:12:32 GMT

Till How many sheets are there in your dashboard?

Re: Global KPI bar

Wed, 17 May 2017 18:19:18 GMT

Thank you for looking at my questions.

There are 7 sheets in my dashboard and 3 of them need to display the same group of KPI object. BTW this is Qlikview dashboard.

Re: Global KPI bar

Anil_Babu_Samineni — Wed, 17 May 2017 18:24:42 GMT

If you have only 3 sheets and I may suggest you to copy paste those. And pause that ID to all the same for all KPI's?

Re: Global KPI bar

Wed, 17 May 2017 18:30:37 GMT

I know copy & paste linked object is a solution. I was wondering if there is better solution.

Thank you Anil.

Sarah

Re: Global KPI bar

oscar_ortiz — Wed, 17 May 2017 20:52:38 GMT

Sarah,

Linked objects would be your better solution. Otherwise you're looking at creating a bunch of hidden objects on the same sheet to mimic the process of selecting other sheets. What I mean by that is that if you needed the KPI bar across three sheets you could add all of the objects from the three sheets onto a single sheet and show or hide based upon a navigation button object that you would create. It gets a little complex in trying to deal with, but it could be done. Again, not a better solution. Simply a different solution.

Good Luck

Oscar

Re: Global KPI bar

Digvijay_Singh — Wed, 17 May 2017 21:02:29 GMT

Keeping those objects in a container may be an option but many users don't like them.

Re: Global KPI bar

Wed, 17 May 2017 22:12:02 GMT

Yes totally agree. Thank you Oscar.

Re: Global KPI bar

Wed, 17 May 2017 22:17:41 GMT

Actually I have tried putting these KPI objects into a container, but for some reason, sometimes for the container I have created,the "Object" selection is grayed out when I select "Copy to Clipboard", therefore I am not able to do the copy & paste linked container to other sheet. Not sure why.

Thank you Digvijay.

Re: Global KPI bar

Siva_Sankar — Thu, 18 May 2017 02:45:21 GMT

Sarah,

May I know why you are avoiding linked objects since it is the best solution for your requirement?

Siva

Re: Global KPI bar

Thu, 18 May 2017 16:09:28 GMT

If I just modify existing KPI object, linked objects solution works for sure, the change in one sheet would reflect automatically to other sheet, simple and easy; but if I create a new KPI, I still need to do copy the KPI from the original sheet, and then paste linked object to other sheets one by one.

I am thinking about if there is graceful solution that works for newly created KPI object, if I add the new KPI in one sheet, the new KPI would be automatically added to other sheets as well. So I don't need to go through the other sheets one by one. That's why I tried container.

Thank you Sivasankar.

Re: Global KPI bar

oscar_ortiz — Thu, 18 May 2017 16:13:19 GMT

Sarah,

One last thought on this would be to check to see if there is an extension built that would handle the situation you are looking to solve. If not, you could always try to create your own.

Again, good luck

Oscar

Re: Global KPI bar

Siva_Sankar — Thu, 18 May 2017 16:33:24 GMT

AFAIK, there is no such way to do that.

You can create default theme in Qlikview. Check here default layout settings

Before you create KPI Object, I strongly recommend you to go through thisCreating a KPI object in QlikView

Siva