Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
sqlpuzzle
Contributor III
Contributor III

Percentage Line Chart

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.

1 Reply
sqlpuzzle
Contributor III
Contributor III
Author

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))