Apply a Filter on a Bar Chart

[itl_qlikview]

Hi all

We are very new on QlikSense. We try to apply a measure filter to a Bar Chart.

In the Bar Chart we have one dimension (ID) and one measure NUMBER calculated as

NUMBER = count(DIM1)

where DIM1 is another dimension of our table.

What we would like to do is showing in our chart only bars for which NUMBER > 1.

We try to insert condition

count(DIM1) > 1

in Add-Ons/Data Handling, but it doesn't seem doing anything.

We suppose that NUMBER isn't aggregated by ID, when it is evaluated in filter.

How can we do to obtain the chart we want?

Thank you

[dplr-rn]

Data handling is done for chart level not for each row.
Try this
if(Count(DIM1)>1,Count(DIM1))

[itl_qlikview]

Already tried... it does not work

[dplr-rn · Accepted solution]

tried that as a measure?

[itl_qlikview]

Ok, after restart, insert expression as measure definition (and not as filter) and set No zero value off, we obtain the result we want.

Thank you very much

[dplr-rn]

no problem