Data Selection Problem

qlik_hunter — Wed, 12 Apr 2023 17:08:09 GMT

Hi Experts,

I am trying to create a measure where I check how many Categories within a Topic have a value of 5 in each of three Functions with my data structured like:

Load * Inline [

Topic, Category, Reporter, Function, Progress

T1, C1, Ralph, A, 5

T1, C1, Ralph, B, 1

T1, C1, Ralph, C, 5

T1, C1, Sam, A, 3

T1, C1, Sam, B, 5

T1, C1, Sam, C, 4

];

with additional entries for Topic (T1, T2, T3, ...) and Category (C1, C2, C3, ...).

My current attempt is:

count(distinct aggr( if( ( max({$<Function={'A'}>} Progress ) = '5' ) AND ( max({$<Function={'B'}>} Progress ) = '5' ) AND ( max({$<Function={'C'}>} Progress ) = '5' ), Category, (Category,Topic)))

But this seems to only work if I filter to a single Topic. Do you have any thoughts or suggestions?

Thank you very much!

Re: Data Selection Problem

qlik_hunter — Wed, 12 Apr 2023 23:54:05 GMT

Edit: I thought this was working earlier, but it appears to be taking the max across Categories in my Bullet plot that has Topic as the Bar Dimension (or at least that is my current theory).

topic Re: Data Selection Problem in App Development

Data Selection Problem

Re: Data Selection Problem