topic Set analysis trouble in QlikView

Set analysis trouble

Thu, 20 Nov 2014 14:15:48 GMT

Hello guys,

I have a count being made with a set analysis expression, but the thing is, I want the set analysis to be independent from my selection, but I cannot integrate what I already have and the {>1}.

The expression I have now is:

=Count({<ZonaTeste={'PT1)'},ResultadoTeste={'0'}>} distinct KNR)

How do I integrate here (syntax wise) the {>1} parameter?

Thank you in advance.

Best regards.

Re: Set analysis trouble

alexandros17 — Thu, 20 Nov 2014 14:17:41 GMT

=Count({<ZonaTeste={'PT1)'},ResultadoTeste={'0'}, myField={'>1'}>} distinct KNR)

where myField is your parameter ...

let me know

Re: Set analysis trouble

Thu, 20 Nov 2014 14:58:31 GMT

EDIT: My bad, it works nicely

I have now:

Count({<ZonaTeste={'PT1)'},ResultadoTeste={'0'}, KNR={'>1'}>} distinct KNR)

maybe the fact of me using KNR on the set analysis and the count has something to do with it.