Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Already tried... it does not work
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