Plot S-Curve Line Chart with Only Start & End Values

[SimonDB]

Hi, I hope someone out there can please help me with this.

I have a data set that has fixed date increments for each project and a start & end value. I'm trying to plot a S Curve line chart when a specific project is selected (as the sample picture below) with the dates as dimension and I need to calculate the values between the start and end values. Any ideas to calculate this either in the script or the chart would be greatly appreciated, thanks

My Data looks something like this:

LOAD * INLINE [
Project Row Number, Project Name, Quarter Date, Start Value, End Value
1, TEST1, 01/01/2026, 150,000, 10,000,000
2, TEST1, 01/04/2026, 150,000, 10,000,000
3, TEST1, 01/07/2026, 150,000, 10,000,000
4, TEST1, 01/10/2026, 150,000, 10,000,000
5, TEST1, 01/01/2027, 150,000, 10,000,000
6, TEST1, 01/04/2027, 150,000, 10,000,000
7, TEST1, 01/07/2027, 150,000, 10,000,000
8, TEST1, 01/10/2027, 150,000, 10,000,000
9, TEST1, 01/01/2028, 150,000, 10,000,000
10, TEST1, 01/04/2028, 150,000, 10,000,000
1, TEST 2, 01/01/2022, 0, 2,500,000
2, TEST 2, 01/04/2022, 0, 2,500,000
3, TEST 2, 01/07/2022, 0, 2,500,000
4, TEST 2, 01/10/2022, 0, 2,500,000
5, TEST 2, 01/01/2023, 0, 2,500,000
6, TEST 2, 01/04/2023, 0, 2,500,000
1, 3 TEST, 01/01/2023, 800, 12,000
2, 3 TEST, 01/04/2023, 800, 12,000
3, 3 TEST, 01/07/2023, 800, 12,000
4, 3 TEST, 01/10/2023, 800, 12,000
5, 3 TEST, 01/01/2024, 800, 12,000
6, 3 TEST, 01/04/2024, 800, 12,000
7, 3 TEST, 01/07/2024, 800, 12,000
8, 3 TEST, 01/10/2024, 800, 12,000
];

[krishna_2644]

Hi - 

1. Make a list box with 'Project Name,' field
2. Create a Line Chart with 'Quarter Date' as dimension
3. measure = [End Value] - [Start Value]

As your [End Value] , [Start Value] are constant  across any given TEST, you see a straight line rather than a curve.

[SimonDB]

Hi, this wouldn't work for me. The Start Value sits with the first date and the end value sits with the last date. I need to calculate the values as a S Curve for the dates between the start and end. I believe this can be done using STDEV and/or NORMDIST, but I've no idea how to plot the expression 

[SimonDB · Accepted solution]

@MarcoWedel helped me solve this in this post

Solved: Re: Logistic curve - Qlik Community - 1885433