Multiply defined values across a field in Bar Chat in Qlik Sense

LP27 — Sat, 16 Nov 2024 20:24:52 GMT

Hi Everyone,

If some one could assist me in solving the below logic-

Table 1

Table 2

Table 3 - Output

Each Project will be having P1 to P8( as shown in Table 2)

P1 is calculated by = (Planed Time) * (P1 Percentage)

Ex : ABC = 700 * 16.05%

P2 is calculated by = (Planed Time) * (P2 Percentage)

Ex : ABC = 700 * 7.80%

P3 is calculated by = (Planed Time) * (P3 Percentage)

Ex : ABC = 700 * 10.13%

P4 is calculated by = (Planed Time) * (P4 Percentage)

Ex : ABC = 700 * 11.14%

P5 is calculated by = (Planed Time) * (P5 Percentage)

Ex : ABC = 700 * 10.11%

P6 is calculated by = (Planed Time) * (P6 Percentage)

Ex : ABC = 700 * 25.38%

P7 is calculated by = (Planed Time) * (P7 Percentage)

Ex : ABC = 700 * 10.88%

P8 is calculated by = (Planed Time) * (P8 Percentage)

Ex : ABC = 700 * 8.32%

Note : Percentages values are fixed as defined in Table 2.

I want the logic to use in Bar chart( may be in measure ), refer the Image attached.

Bar Chart

Please ask me if you have questions.

Thanks in Advance,

LP27

Re: Multiply defined values across a field in Bar Chat in Qlik Sense

sunny_talwar — Mon, 22 Jul 2019 11:19:24 GMT

This

LP27 — Mon, 22 Jul 2019 11:30:08 GMT

Thanks for that logic,

I actually wanted the tables values in line chart shown in image below.

so if i make selection on Project Names, it should calculate for all PR1 to PR8 in the chart.

I have attached QVF for your understanding.

Line Chart