topic QlikView if(count expression help! in QlikView

QlikView if(count expression help!

Tue, 29 Jan 2013 16:43:36 GMT

I need help. I am not a programmer but I work on the design side of QlikView for my employer.

I need to create an analysis that will track the number of in home presentations our sales agents are presenting in a month then determine which ones are closing the presentation into a sale.

Below is a rough template of the analysis that I need to create...

YearMonth # of Presentations given by an Agent Count of Agents w/ ZERO Sales for the Month % of Total Agents with Zero Sales

Jul 2012 0-2

3-4

5-6

7-8

I have attached a sample of the data that is avaialble to me. If there is not a Sale Unique Id then the presentation did not result into a sale.

How would I write an expressions that would provide the values I need for my data points above? I appreciate any help!!! Thanks a lot.

Re: QlikView if(count expression help!

Nicole-Smith — Tue, 29 Jan 2013 17:10:57 GMT

See attached.

Re: QlikView if(count expression help!

Tue, 29 Jan 2013 17:29:26 GMT

THANK YOU SO MUCH!!!!

Re: QlikView if(count expression help!

Tue, 29 Jan 2013 17:49:53 GMT

Nicole - how Could I create buckets of 0-2, 2-3, 4-5 and 6-7, 8+ ? So that I can create something that tells my upper management the count of agenst with zero sales who only had 2-3 sales, etc... Thanks again.

Re: QlikView if(count expression help!

Nicole-Smith — Tue, 29 Jan 2013 19:22:47 GMT

See attached.

Re: QlikView if(count expression help!

Tue, 29 Jan 2013 21:47:56 GMT

Thanks!