Multiply the constant with values in line chart Qlik sense

[LP27]

Hi Everyone,

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

example -

Line 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.

Phase	Percentage
PR1	16.05%
PR2	7.80%
PR3	10.13%
PR4	11.14%
PR5	10.11%
PR6	25.38%
PR7	10.88%
PR8	8.32%

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

Please let me know if you got questions.

Thanks in advance,

LP27

[sunny_talwar]

Is this what you are looking to get?

[LP27]

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

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

[sunny_talwar · Accepted solution]

This?

[LP27]

Yes, This is what i wanted! 

Thanks a lot!

Appreciate your assistance 🙂