Set Analysis or If Statement?

Tue, 11 Sep 2012 14:06:01 GMT

Hello,

I have the below if statement that gets me the expected result however I don't think it's the best way to do the query. I want to count the number of customers who have used only one TRANSCODE, the other query would be counting customers who use more than one TRANSCODE (so just change = to >).

Would anyone be able to try and get this into set analysis?

count(aggr(if(count(distinct TRANSCODE) =1,1), Customer))

Thanks,

Ralph

Re: Set Analysis or If Statement?

MayilVahanan — Tue, 11 Sep 2012 16:45:52 GMT

Try like this,

Use Customer as dimension:

=Count({<Customer = {"=count(Transcode)=1"}>}Transcode) .

=Count({<Customer = {"=count(Transcode)>1"}>}Transcode)

Hope it helps

topic Re: Set Analysis or If Statement? in QlikView

Set Analysis or If Statement?

Re: Set Analysis or If Statement?