Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

12 Replies
Employee
Employee

Re: Selection disabling on sheet visualizations

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

Re: Selection disabling on sheet visualizations

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

MVP
MVP

Re: Selection disabling on sheet visualizations

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

Re: Selection disabling on sheet visualizations

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
Valued Contributor III

Re: Selection disabling on sheet visualizations

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

Employee
Employee

Re: Selection disabling on sheet visualizations

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

Re: Selection disabling on sheet visualizations

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

Regards,

Mike T

Regards,
Mike Tarallo
Qlik
phaneendra_kunc
Valued Contributor III

Re: Selection disabling on sheet visualizations

Thanks Mike. You are always helpful

Not applicable

Re: Selection disabling on sheet visualizations

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

Community Browser