topic Re: Percentages in a Line Chart in QlikView

Percentages in a Line Chart

Mon, 20 Jan 2014 12:38:15 GMT

I have a percentage of a number that I want to show on a drill chart. For example out of 20 attempts 10 were successful in the first week in December, 15 out of 20 in the second week, 5 out of 20 in the third week and 10 out of 20 in the fourth week. So the percentages by week are 50%, 75%, 25% and 50%. When I am showing months I would like it to show 50% and then drill down to show the different weeks. What format should I use for the expression?

Re: Percentages in a Line Chart

Mon, 20 Jan 2014 12:44:57 GMT

Your Percentage is based on your dimension right? So just add the Drill with Year,Month and Week in order..

Upload some sample data for what exactly you are looking for

Selva

Re: Percentages in a Line Chart

MK_QSL — Mon, 20 Jan 2014 12:49:20 GMT

Block and Mekko Chars are the better solution for this type of problem.

Still we can use other charts also, let us have your sample file.