topic Re: Filter dimensions in a chart in QlikView

Filter dimensions in a chart

Wed, 23 Oct 2013 20:53:03 GMT

I have 4 charts that are point at tables that are filtered by yesterday's date. In one of the bar charts, I want to show the count of any records that have 'Wrong' in the defect field. I could filter the data, but that would compromise the other charts - I'd like to do in the chart itself. In another chart, I want to show the top 5 defects excluding one particular defect (always the highest and skews the data). Any help would be appreciated.

Re: Filter dimensions in a chart

MayilVahanan — Wed, 23 Oct 2013 21:32:06 GMT

Try like this

I want to show the count of any records that have 'Wrong' in the defect field.:

= Count({<defect = {'Wrong'}>} FieldName)

I want to show the top 5 defects excluding one particular defect :

Use dimension limit or rank functions.

Re: Filter dimensions in a chart

Wed, 23 Oct 2013 21:44:48 GMT

I think that is getting me closer. I put that statement in the defintion box of the expressions tab. How would I write this to look for Wrong anywhere in the defect? Something similar to - defect Like '*Wrong*' - in previous work I've done. I tried playing with the syntax, but could never get it right.

Re: Filter dimensions in a chart

MayilVahanan — Wed, 23 Oct 2013 21:55:56 GMT

Try like this

= Count({<defect = {'*Wrong*'}>} FieldName)

Re: Filter dimensions in a chart

Thu, 24 Oct 2013 01:41:27 GMT

Thanks for the help - that did it.

Re: Filter dimensions in a chart

Thu, 24 Oct 2013 11:49:47 GMT

One more question on the other chart - how would the expression look for exclduing one defect? Not like '*Delay*'

Re: Filter dimensions in a chart

MayilVahanan — Thu, 24 Oct 2013 12:27:07 GMT

Try like this

= Count({<defect -= {'*Delay*'}>} FieldName)

Re: Filter dimensions in a chart

Thu, 24 Oct 2013 12:54:36 GMT

Thanks again - that did it as well. Was not familiar with the '-=' as not equal, but am now.