Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
LP27
Creator II
Creator II

Multiply the constant with values in line chart Qlik sense

Hi Everyone,

I am trying to create a line chart in Qlik Sense for calculating time.

example -

Line chartLine chart

 

The logic to calculate the line chart is=

Planed Time * Percentage 

For example-

if i select project name and its planned time is 700, then it should calculate 

P1= Planned Time  * PR1 Percentage( percentages are provided in table below)

So: P1=700*16.05% = 112

P2=700*7.08% = 55

P3=700*10.13%=71

So on till PR8.

PhasePercentage
PR116.05%
PR27.80%
PR310.13%
PR411.14%
PR510.11%
PR625.38%
PR710.88%
PR88.32%

 

Now i need ways to show the output in Line chart.

 

Please let me know if you got questions.

 

Thanks in advance,

LP27

 

 

 

1 Solution

Accepted Solutions
sunny_talwar

4 Replies
sunny_talwar

Is this what you are looking to get?

image.png

LP27
Creator II
Creator II
Author

Yes, But it should also work when you make selection  to the Project Name it should show the calculated line  accordingly as picture below-

line.PNG

 

Note- For all the Project Names it should display all the values from PR1 to PR8 in line chart.

sunny_talwar

LP27
Creator II
Creator II
Author

Yes, This is what i wanted! 

Thanks a lot!

Appreciate your assistance 🙂