topic Re: Set analysis in QlikView

Set analysis

Mon, 26 Nov 2012 14:53:51 GMT

Hi!

I have some problems with set analysis. How do I do it?

I want to count the "Personnr" if count(distinct InvoiceNo)=0.

I tried do write it like this (but error):

count({$<count(distinct InvoiceNo)={0}>} Personnr)

Can you help me?

/Julia

swuehl — Mon, 26 Nov 2012 15:32:06 GMT

If I understood your request correctly, maybe like this:

count({$<Personnr = {"=count(distinct InvoiceNo)=0"} >} DISTINCT Personnr)

Gysbert_Wassenaar — Mon, 26 Nov 2012 15:32:32 GMT

Isn't that a count of Personnr without invoices:

count({$<InvoiceNo-={'*'}>} Personnr)

btw, the editor doesn't understand -= ,but it works nonetheless

Mon, 26 Nov 2012 15:55:58 GMT

Thanks!

Mon, 26 Nov 2012 15:56:32 GMT

Thanks