Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selection disabling on sheet visualizations

Hi all,

In bar chart if i clicks on bar it select the bar and it filters the sheet through the value of the bar,

Is it possible to disable the selection on charts.

Thanks,

Pramod

13 Replies
Michael_Tarallo
Employee
Employee

Hi Pramod -

This is actually possible through a technique when defining the measure using Set Analysis:

You can see a video on this here:A Beginners' Introduction to Set Analysis (video)

Found on our main video index here: New to Qlik Sense Videos

With Set Analysis - you can define a measure to ignore selections and therefore when one selects in the chart, the chart WILL not reflect the selection.

Sum({1}Sales)

The #1 - means to ignore the selection.

Hope this is useful.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Not applicable
Author

Hi tarallo,

I am using the set analysis like below:

Count({1<subject_id={1},is_correct_answer={1},test_type={"FinalTest"}>}question_id)

but also if i click on the bars on bar chart. it will select the data and filter other charts in the sheet.

Thanks,

Pramod

jonathandienst
Partner - Champion III
Partner - Champion III

Make the chart Read-Only - Chart Properties | General - check the Read Only check box. Now the user cannot make selections on the chart. Is that what you required?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Michael_Tarallo
Employee
Employee

Hi Pramod - I assume you are speaking of Qlik Sense - not QlikView correct, as you posted in the Qlik Sense forum. Jonathan is speaking of QlikView.

In regards to your follow-up - you would need to define this Set Analysis measure in all chart objects that you do not want to update, or therefore ignore the selection and not be filtered.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Mike,

Do you think in near future we will have "No Interaction" (Read only) feature in sense objects?

I see we have this option on single objects (https://localhost/single/)

Thanks,

Phani

Michael_Tarallo
Employee
Employee

Hi Phani - it is a good idea, I would like to see that. A simple read-only checkbox or something similiar.

yes I see that --- hmmm don't think it would be too hard to add that, let me open a feature request.

Regards,
Mike Tarallo
Qlik
Michael_Tarallo
Employee
Employee

For your reference, here is the internal case number: QLIK-37360

Regards,

Mike T

Regards,
Mike Tarallo
Qlik
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Thanks Mike. You are always helpful

Not applicable
Author

Yes Tarallo, i am speaking about Qlik sense.

I have tried {1} for all the measures field. Now, selections is not happening when clicked on bars, but one more issue is in the same sheet i have two filter panes. If try to filter the through filter pane, it's not filtering. I need to filter the data through filter pane but not through clicking on bars.

Please see the attached image.

count1.png

Thanks,

Pramod