topic Re: Sum and Count in summary column in QlikView

Sum and Count in summary column

Wed, 12 Oct 2011 09:43:53 GMT

Dear All,

Please find the attached documents , i need the output as mentioned in sheet2, with sum and count values in summary row for all expressions.

I trired with dimensionality function it works for me for one expression others does not.

Regards,

Ravi.

Sokkorn — Wed, 12 Oct 2011 11:27:05 GMT

Hi Ravi,

In your attached file don't have sheet2, so please attache file again or reply me back what you want.

Regards,

Sokkorn

Wed, 12 Oct 2011 11:34:17 GMT

Hi Sokkorn,

Thanks for your quick reply but i got the solution with dimensionality function().

Regards,

Ravi.

Sokkorn — Wed, 12 Oct 2011 11:38:32 GMT

Hey Ravi,

Let me cheer with you .

Regards,

Sokkorn

Wed, 12 Oct 2011 11:43:57 GMT

Hi Sokkorn,

For your reference, please have a look into below script.

=if(dimensionality()=0,sum(sales)& '/ ' & Count(Distinct pono),sum(sales))

Regards,

Ravi.