topic Re: Hide Row in Chart base on expression column in QlikView

Hide Row in Chart base on expression column

Sat, 10 Nov 2012 06:04:22 GMT

I am trying to create a pivot table with 1 dimension (A) and 1 expression (Count of A). I want to result set shows expression result > 1 only.

Example:

Data:

Row 1: A = 123

Row 2: A = 123

Row 3: A = 455

Row 4: A = 345

Row 5: A = 345

Row 6: A = 345

Row 7: A = 111

I want the resulting pivot table shows:

A Count of A

123 2

345 3

Try using count in dimension but doesn't work. Any other options/suggestion?

Re: Hide Row in Chart base on expression column

Anonymous — Sat, 10 Nov 2012 07:21:02 GMT

No need to do the count as a dimension.

Set the field with A as a dimension, then Count(Fieldname) as expression.

Go to the tab called dimension limits and activate the limits with the checkbox and set "Show only values that are greater than", 1, and "Exact amount".

Re: Hide Row in Chart base on expression column

Sun, 18 Nov 2012 05:49:18 GMT

Thanks Johannes. It works.