Qlik Community

Qlik Sense App Development

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

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
LP27
Contributor

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

Hi Everyone,

 

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

Table 1 

Project NamePlanned Time
ABC700
XYZ154

 

Table 2

PhasePercentage
P116.05%
P27.80%
P310.13%
P411.14%
P510.11%
P625.38%
P710.88%
P88.32%

 

Table 3 - Output

Project NameP1P2P3P4P5P6P7P8
ABC112557178711787658
XYZ2311151615371612

 

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.

Capture.PNGBar Chart

 

 

Please ask me if you have questions.

 

Thanks in Advance,

LP27

 

 

 

 

 

2 Replies

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

This

image.png

LP27
Contributor

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

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.

 

c.PNGLine Chart