Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Creating multiple charts in a single sheet with their own filters

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

1 Solution
7 Replies
Anonymous
Not applicable
Author

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.

sunny_talwar

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.

Capture.PNG

Anonymous
Not applicable
Author

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!!!!!!!!!!!!!!!!!!!!

sunny_talwar

Awesome

I am glad it finally worked out

Best,

Sunny

khoebing
Contributor
Contributor

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

 

Patricia_Silva
Specialist II
Specialist II

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

Help users find answers! Don't forget to mark a correct resolution 🙂