Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sean_corrigan
New Contributor

Filter Chart Data

Hello

I have a bar chart that sums the value Grade with the dimension being GradingName on the x axis (.e.g. Target, Actual etc.) I only want to display some of the GradingNames on the chart and cannot see how to include just the ones I want. I only want to filter it on the chart as in other areas of the dashboard I use all GradingNames.

Thanks!

Tags (1)
7 Replies
isingh30
Contributor III

Re: Filter Chart Data

On what basis you want to filter? Please show data or sample application

Thanks

sean_corrigan
New Contributor

Re: Filter Chart Data

The field "txtGradingName" pulls through a number of grading names stored in the database. Please see the chart below, for example I only want to display Attitude to Learning, Homework and Use of English on the chart.

Thanks

Capture.PNG

ogster1974
Honored Contributor II

Re: Filter Chart Data

Either use limitation i.e top 5 etc...

or

make your dimension a calculated dimension in master items something like

If(gradingname={'A', 'B', 'C', 'D'},gradingname, null())

And then exclude the null values.

Regards

Andy

ogster1974
Honored Contributor II

Re: Filter Chart Data

So having a calculated dimension

If(txtgradingname={'Attitude to learning ', 'homework', 'Use of english},txtgradingname, null())


And then excluding nulls in your dimension will give you what you need.


Regards



Andy

sean_corrigan
New Contributor

Re: Filter Chart Data

Hi Andy

Thank you very much for your reply. I have tried adding the calculated dimension, however, I receive an "Error in expression" message:

Capture 1.png

Many thanks

Sean

_armoco_
Contributor

Re: Filter Chart Data

A simple set analysis as the expression perhaps?

Sum({<txtGradingName={'A','B','C'}>}txtGrade)

Where A,B and C will be Grading names

mikaelsc
Contributor III

Re: Filter Chart Data

If(match(txtgradingname,'Attitude to learning ', 'homework', 'Use of english'),txtgradingname, null())


not sure what the syntax of andy should be :-)