Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

Ability to freeze chart?

Hello all.

 

I have  created  a line chart. X-axis is about master calendar date and y-axis is a sum.

Due to poor date data  entrance (which also I'm asked to show so, so i'm not allowed to manage them), the line chart is very suffocated and I only need to focus on some years, or start scrolling from some years and forward, or like freeze the chart.

 

 

Is something like that possible?

4 Replies
Highlighted
Partner
Partner

Re: Ability to freeze chart?

Hi Ioan,

Yes, you can do this by using set analysis in your Sum(). For instance, you sum Sales, but you don't want the year to interfere. Then you can try this:

Sum({1< Year =>}Sales)

Jordy

Climber 

Work smarter, not harder
Highlighted
Contributor

Re: Ability to freeze chart?

Thank you!

But I need to refer the year range I want to show, right?

Highlighted
Contributor

Re: Ability to freeze chart?

Yup it worked! Thanks! Do you maybe know if it's possible to still scroll in the chart but with this year selection to be the first thing someone sees?

Highlighted
Partner
Partner

Re: Ability to freeze chart?

Yes that is also possible, for this you can create a standard bookmark. Check this video for the explanation.

Jordy

Climber

Work smarter, not harder