topic Re: Plot S-Curve Line Chart with Only Start & End Values in App Development

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

SimonDB — Tue, 25 Jan 2022 23:01:46 GMT

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
];

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

Qrishna — Tue, 25 Jan 2022 23:45:18 GMT

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.

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

SimonDB — Wed, 26 Jan 2022 08:42:12 GMT

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

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

SimonDB — Wed, 26 Jan 2022 22:03:39 GMT

@MarcoWedel helped me solve this in this post

Solved: Re: Logistic curve - Qlik Community - 1885433