topic Re: Chart Data Exclusion in QlikView

Chart Data Exclusion

Anonymous — Tue, 11 Jun 2013 20:26:30 GMT

Hi All,

I have a built a chart showing student data with my dimension by Grade.

My data has some grade values that I need to filter out for this specific chart: IN (independent study), 99 (Adult study).

I want these values in my listboxes and other modules, just not in the chart.

How can I exclude 'IN' and '99' from my dimension in just this chart?

Also, for future reference: how can this be done in the script to prevent these values from showing up anywhere in the application?

I have tried to use conditional formatting in my dimension - not sure if I am on the right track though.

Thank you!

Re: Chart Data Exclusion

Tue, 11 Jun 2013 20:48:50 GMT

You can use either an IF statement or set analysis in order to filter it out for just one chart. In the script, you can use a WHERE statement.

Set analysis:

Sum({$<Value-={'IN','99'}>} StudentGrade)

Script:

LOAD
yourfields here

FROM

source here

Where Value<>'IN' and Value<>'99';

Note that if you put it in the script, those values will no longer appear in your list boxes, etc.

Re: Chart Data Exclusion

Anonymous — Tue, 11 Jun 2013 20:58:48 GMT

Rebecca,

I believe that I would need to exclude these values without aggregation.

My current expression is: count(if(L1Saved='1',L1Saved))/(count(studentId))

Thank you for answering my secondary question - that definately helps if I would need certain values to be excluded entirely.

Re: Chart Data Exclusion

Tue, 11 Jun 2013 21:42:33 GMT

Sounds like you need something like this:

Count(({$<L1Saved={'1'},Value-={'IN','99'}>} L1Saved)/Count({$<Value-={'IN','99'}>} studentId)

Re: Chart Data Exclusion

Anonymous — Tue, 11 Jun 2013 21:53:23 GMT

Hi Rebecca this did not work for me - gave me "no data to display"

Re: Chart Data Exclusion

Tue, 11 Jun 2013 21:54:57 GMT

Okay, then I would have to see your data. Do you have a sample file?

Re: Chart Data Exclusion

Anonymous — Tue, 11 Jun 2013 22:12:41 GMT

Here is a sample file where I would need to exclude grades PK and 99

Re: Chart Data Exclusion

prodanov — Wed, 12 Jun 2013 10:11:43 GMT

Try this:

count({<Grade-={'99','PK'}>} if(L1Saved='1',L1Saved))/(count({<Grade-={'99','PK'}>}studentId))

Re: Chart Data Exclusion

Wed, 12 Jun 2013 13:05:36 GMT

See attached.

Re: Chart Data Exclusion

Anonymous — Wed, 12 Jun 2013 18:06:03 GMT

Thank you Prodanov, This works!

Re: Chart Data Exclusion

Anonymous — Wed, 12 Jun 2013 18:06:19 GMT

Thank you Rebecca, This works!!