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

Multiply the constant with values in line chart Qlik sense

LP27 — Sat, 16 Nov 2024 05:12:35 GMT

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.

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 — Mon, 22 Jul 2019 12:31:19 GMT

Is this what you are looking to get?

LP27 — Mon, 22 Jul 2019 12:49:01 GMT

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 — Mon, 22 Jul 2019 12:53:20 GMT

This?

LP27 — Mon, 22 Jul 2019 13:04:11 GMT

Yes, This is what i wanted!

Thanks a lot!

Appreciate your assistance 🙂