Qlik Community

Qlik Sense App Development

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

Highlighted
LP27
New Contributor III

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 -

c.PNGLine 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

Re: Multiply the constant with values in line chart Qlik sense

This?

image.png

4 Replies

Re: Multiply the constant with values in line chart Qlik sense

Is this what you are looking to get?

image.png

LP27
New Contributor III

Re: Multiply the constant with values in line chart Qlik sense

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.

Re: Multiply the constant with values in line chart Qlik sense

This?

image.png

LP27
New Contributor III

Re: Multiply the constant with values in line chart Qlik sense

Yes, This is what i wanted! 

Thanks a lot!

Appreciate your assistance 🙂