8 Replies Latest reply: Feb 21, 2013 1:44 PM by Jim Chadwick RSS

    a question about counts

      So, I want to make a chart.

       

      on the Y axis, I want to have percentages. 10% increments, from 0% to 100%.

       

      What I want to calculate... this is where I have an issue.

       

      I have a field called "sent_date", and a field called "received_date". These all have a unique identifier called a "apl_id". So, each apl_id has a date it was received by my company, and a date where it was sent out to the member. They must be sent out within 30 days of receiving them.

       

      If, let's say, for the month of October, we have 100 apl_id's, with 100 received dates and 100 sent dates, if all 100 were sent out within 30 days of receiving them, the chart would show 100% for the month of October. If one was outside of the 30 days, it would need to show 99%.

       

      I haven't a clue how to do this calculation inside of Qlikview.

       

      Is there a way to have a chart do the calculations behind the scenes, and then present them in the chart as a percentage?

       

      I suppose it would need to do an IF statement, like "IF >= 30, then count it as a 1. If not, count as a 0 (or dont count at all).... then you would put this inside of the chart?

       

      Please help!!!