topic Percentage Line Chart in QlikView

Percentage Line Chart

sqlpuzzle — Wed, 25 Nov 2020 16:16:04 GMT

I need help in creating a line Chart with percentage of a measure along the time dimension, subsetted with a Type dimension.

So I will be able to see what is the percentage approval rate or non approval rate is for different months.

I am attaching the sample I have.

Re: Percentage Line Chart

sqlpuzzle — Wed, 26 Jul 2017 14:42:52 GMT

I think I have it.

=(Count({<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'}>} country))/(Count(TOTAL <[Month Year]> {<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'}>} country))