Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

counting problem

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??5.bmp

Tags (1)
3 Replies
MVP
MVP

Re: counting problem

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

or

Simply

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

sicilianif
Contributor

Re: counting problem

Use set analysis. Something like this

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

MVP
MVP

Re: counting problem

maybe with a calculated dimension

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

and check Suppress when value is null