topic Re: counting problem in QlikView

counting problem

Wed, 17 Sep 2014 13:35:12 GMT

Hi! i'm working on this project and i want to crate an object that shows me only the number of 'controllo' that have 'Numero Domanda'= 1. i try to do this with a pivot table where in the expression i inserted the following condition "count(distinct(Domanda))" it works, but i want to see the number of controllo that have 'numero domanda' =1 .How i can solve this problem??

Re: counting problem

MK_QSL — Wed, 17 Sep 2014 13:37:32 GMT

COUNT(Aggr(COUNT({<Numero_Domande = {1}>}Distinct CONTROLLO),CONTROLLO))

Simply

COUNT({<Numero_Domande = {1}>}Distinct CONTROLLO)

Re: counting problem

sicilianif — Wed, 17 Sep 2014 13:37:39 GMT

Use set analysis. Something like this

count({<Numero_Domande={'1'}>} distinct Domanda)

Re: counting problem

maxgro — Wed, 17 Sep 2014 19:37:41 GMT

maybe with a calculated dimension

=if(aggr(sum(domande),controllo)>1,null(),controllo)

and check Suppress when value is null