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?
Then under the Number tab, set your expression to Show in Percent.
(if you have lots and lots of those apl_id's you might want to set a flag as 1 for each instance in the script and then use sum(apl_flag) instead of count(apl_id) but for a normal dataset you shouldn't need to worry.)
Also, in your other thread the sent date is called apel_ltr_snt_dt in which case the syntax in my previous example is wrong. Make sure that the fieldnames in the expression matches what you have in your data model.