Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

How to get total value In the table, put a bar graph.

I want to put the Total %Scrap value on the graph.

Paknanarn23_0-1701057687580.png

The conditions will be WorkCenter = MIC,TCC,TCL,TCE,DES.

This is the code used to calculate %Scrap.

Paknanarn23_1-1701057780576.png

What should I do? please help me

 

 

 

4 Replies
tabletuner
Creator III
Creator III

Do I understand clearly that you want the whole column %Scrap to be filled with the value 7.02% ?

Paknanarn23
Creator II
Creator II
Author

Yes, you understood correctly, I want to 7.02% shown in the graph

tabletuner
Creator III
Creator III

Note the addition of the TOTAL statement. 

=Sum(TOTAL {<Plant, etc>}/
if(GetFieldSelections(WorkCore)='INNER',
Sum(TOTAL {<WorkCore_SSD='INNER'},etc
Sum(TOTAL {<WorkCore_SSD='OUTER'},etc

Would this solve the problem?

tabletuner
Creator III
Creator III

Hi, did my answer help you? Please mark as solved then 🙂