topic Re: Filtering out a specific row in QlikView

Filtering out a specific row

Thu, 01 Nov 2012 12:35:05 GMT

Hi,

I have data by regions in a table in column 1. Some of the values in this column are a sum of all the regions and called "All". I would like to filter these values out from the graphs when they are plotted as they make all the other regional data bars look too small. How can I do this?

Secondly, I can only drill down data to 1 level below, but would like to drill down further. Is this possible?

Im using QlikView Personal Edition on my desktop.

Kind regards,

Re: Filtering out a specific row

Thu, 01 Nov 2012 13:40:38 GMT

You can use an IF statement or set analysis, depending on your situation. For example, IF(Region<>'ALL',Sum(Values)) or Sum({$<Region-={'All'}>} Values). Hope that helps.

Re: Filtering out a specific row

Thu, 01 Nov 2012 14:52:16 GMT

Thanks rebeccad. Id want to exclue the value which say 'All'. How do I do that?

Re: Filtering out a specific row

Thu, 01 Nov 2012 14:56:27 GMT

Do you have a sample file?

Re: Filtering out a specific row

MayilVahanan — Thu, 01 Nov 2012 14:56:48 GMT

Sum({$<Region -= {'All'}>} Values) this exclude the 'All' value in region field and calculate the others

for additional information:

if you want to exclude all selection means,

try like this

=sum({1}Values)

Re: Filtering out a specific row

Thu, 01 Nov 2012 15:02:12 GMT

It says Calculation condition unfulfilled. Doesn’t seem to work.

Jaleed

Re: Filtering out a specific row

MayilVahanan — Thu, 01 Nov 2012 15:09:13 GMT

Its working for me.

=Count({<[Episode Number] -= {1}>}[Title Name])

Can you provide a sample file?

Re: Filtering out a specific row

Thu, 01 Nov 2012 15:09:56 GMT

Do you have an expression in calculation condition? If you had a problem in the expression, it would show no value, not 'Calculation Condition Unfulfilled'.

Re: Filtering out a specific row

Thu, 01 Nov 2012 15:22:01 GMT

Attached are the sample file and data

Re: Filtering out a specific row

MayilVahanan — Thu, 01 Nov 2012 15:24:36 GMT

PFA.

In this, All region excluded in bar chart.

Re: Filtering out a specific row

Thu, 01 Nov 2012 15:28:14 GMT

See attached.

Re: Filtering out a specific row

Thu, 01 Nov 2012 15:29:13 GMT

Where did you type the formula? I was typing under properties

Re: Filtering out a specific row

Thu, 01 Nov 2012 15:30:00 GMT

You type it in Dimensions.

Re: Filtering out a specific row

Thu, 01 Nov 2012 15:31:16 GMT

Highlighted in blue.

Re: Filtering out a specific row

MayilVahanan — Thu, 01 Nov 2012 15:32:46 GMT

Used In expression tab..with set analysis..

Mr.Rebeccad used in dimension.. both give the answer..

Set anaysis gives better performance when compare to if condition.

hope it helps