topic Creating multiple charts in a single sheet with their own filters in QlikView

Creating multiple charts in a single sheet with their own filters

Anonymous — Fri, 07 Oct 2016 20:43:04 GMT

Hi There-

My client wants to see a report where there are multiple bar charts on one page each showing something different. There could be 20 of these bar charts and they will need to be able to scroll down one single sheet and see each one. Each bar chart needs to have its own list box of filters that only effects that one bar chart.

They don't want multiple tabs. they want one single sheet that can scroll down to show many pages.

So two questions:

1. Is it possible to have multiple charts on one sheet with their own filter box? I noticed if I tried to create multiple bar charts and put them in their own containers with their own list box filters, if I changed the filter for one chart, it effected every chart.

2. If the above is possible, can I have one single sheet that scrolls down to show many pages that contain all these bar charts?

I have included a slide from a power point deck that shows what I am talking about. Basically they want to replicate this, so imagine a powerpoint deck with maybe 10 slides. each slide has 2 or 3 bar charts with their own filters and you can scroll down through each slide and adjust filters for each bar chart without it effecting the rest of the bar charts.

I hope this makes sense.

Thanks

Re: Creating multiple charts in a single sheet with their own filters

sunny_talwar — Fri, 07 Oct 2016 21:19:51 GMT

I think both the things are possible. You need to look into Alternate State here for different filter for each of your object

Qlikview-Alternate States Fundamental-Inheritted vs Default

http://www.learnqlickview.com/alternate-states-in-qlikview/

http://www.qlikfix.com/2014/08/12/alternate-states/

Qlikview Alternate States - YouTube

Re: Creating multiple charts in a single sheet with their own filters

Anonymous — Fri, 07 Oct 2016 22:54:59 GMT

That worked!! Thank you.

Now how do I make my sheet longer? Or how do I add a new page to the existing sheet so my client can keep scrolling down to view each chart that I need to add? Remember I prefer not to have it on multiple tabs, I need a single long scrolling sheet.

Re: Creating multiple charts in a single sheet with their own filters

sunny_talwar — Sun, 09 Oct 2016 05:42:26 GMT

I think as you create objects and move them down, QlikView will automatically create a scrollbar for you. You can fasten this process by creating a text box object and go on the 'Caption' tab and make the y position really high so that the object goes down to view your scrollbar on the right.

Re: Creating multiple charts in a single sheet with their own filters

Anonymous — Sun, 09 Oct 2016 13:52:30 GMT

Sunny T - I couldn't get it to work, by adding new charts. But using the text object and y axis tip you gave me worked like a charm. I now have a very long scrolling sheet.

THANK YOU!!!!!!!!!!!!!!!!!!!!

Re: Creating multiple charts in a single sheet with their own filters

sunny_talwar — Mon, 10 Oct 2016 12:26:04 GMT

Awesome

I am glad it finally worked out

Best,

Sunny

Re: Creating multiple charts in a single sheet with their own filters

khoebing — Wed, 12 Jan 2022 21:20:23 GMT

Hello. do you know how to perform this action for the web based version of Qlik?

Re: Creating multiple charts in a single sheet with their own filters

Patricia_Silva — Wed, 12 Jan 2022 23:17:03 GMT

Hello @khoebing, do you mean in Qlik Sense Enterprise SaaS? Or Qlik Sense Enterprise on Windows?