Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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