5 Replies Latest reply: Jan 29, 2013 4:47 PM by Robyn Talley RSS

    QlikView if(count expression help!

      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

                                   9+

       

       

      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.