Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Im trying to create a bar chart where the expression is a count a number of items, whose 'Counter' is greater than 1. these items and counter are failures are filtered by their kind.
my syntax thus looks like this:
if (
Sum({<[Kind]={$(='animal')}>}[Counter]) > 1
, Count({<[Kind]={$(='animal')}>}DISTINCT [ItemNumber])
)
however, it does not work. thoughts?
may be this
Count({<[Kind]={"=Sum({<[Kind]={'animal'}>}[Counter]) > 1"}>}DISTINCT [ItemNumber])
@AngieO2019 Are you using Qlik Sense or QlikView? I would like to move this into the correct product forum.
may be this
Count({<[Kind]={"=Sum({<[Kind]={'animal'}>}[Counter]) > 1"}>}DISTINCT [ItemNumber])
Hi Sue,
I'm currently using qlikview.