Qlik Community

App Development

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

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
LP27
Creator II
Creator II

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.

Bar ChartBar Chart

 

 

Please ask me if you have questions.

 

Thanks in Advance,

LP27

 

 

 

 

 

Labels (4)
2 Replies
sunny_talwar

This

image.png

LP27
Creator II
Creator II
Author

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 ChartLine Chart