topic Re: Group Count Result (with totals) in QlikView

Group Count Result (with totals)

Wed, 03 Jul 2013 19:33:32 GMT

Hi,

I am counting a field (called TYPE) and the result is ok.

What I need is to list the the values of dimension and respective totals grouped by count result.

Count OK:

What I want:

Thank You!

Gysbert_Wassenaar — Wed, 03 Jul 2013 19:47:38 GMT

See attached example. No idea how to get the lines for frequency 0 though.

Tue, 09 Jul 2013 19:40:34 GMT

Nice.

I just added TIPO={'D'} and works fine!

count({<TYPE={'D'}, TYPE={'T'}>}DISTINCT COUNTRY)

//count({<TYPE={'T'}>}DISTINCT COUNTRY)

and after that, change set null symbol (tab presentation) the text: 0 Frequency