Conditions and Nested Set Analysis

[AngieO2019]

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?

[Sue_Macaluso]

@AngieO2019 Are you using Qlik Sense or QlikView?  I would like to move this into the correct product forum. 

[Kushal_Chawda · Accepted solution]

may be this

Count({<[Kind]={"=Sum({<[Kind]={'animal'}>}[Counter]) > 1"}>}DISTINCT [ItemNumber])

[AngieO2019]

Hi Sue,

I'm currently using qlikview.