Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Gilpe
Contributor
Contributor

Roll Rate line chart

Hello, i want to create a line chart to show a calculation of roll rate.

my time intervals is 30days, 60days,90days and 120days.

in my data set i have an indicator (1,0) for each observation that indicate if she relevant to the calculate of the specific time period.

I'm doing the calculation of the roll rate inside the qlik sense and when i put it on line chart i get new line for each time period calculation (line for 30d roll rate, line for 60d roll rate etc).

insted of this i want to put the days as dimension and the proportion of the roll rate on the line.

means that i want to see one line chart and on x-axis i want to see for exp '30d' and on the  y - axis the proportion, 60d on x-axis and the proportion on y - axis etc.

I'm not sure  how to do this. is there a way to create a"free hand" dimension that i can write the label for exp 30d and to attach the right calculation to him?

thanks alot!

Labels (3)
1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi,

Do you maybe have some data for us to test? And maybe a sketch of how your graph will look like will also really help us.

Jordy

Climber

Work smarter, not harder