topic Re: Conditions and Nested Set Analysis in QlikView

Conditions and Nested Set Analysis

AngieO2019 — Sat, 16 Nov 2024 19:17:13 GMT

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?

Re: Conditions and Nested Set Analysis

Sue_Macaluso — Fri, 17 Jan 2020 13:26:46 GMT

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

Re: Conditions and Nested Set Analysis

Kushal_Chawda — Fri, 17 Jan 2020 13:27:45 GMT

may be this

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

Re: Conditions and Nested Set Analysis

AngieO2019 — Fri, 17 Jan 2020 13:28:53 GMT

Hi Sue,

I'm currently using qlikview.