Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Drece-gkn
Contributor III
Contributor III

Assigning values to Part #'s

Hello, 

I have a chart visualization that I need to add a column to. I have a column that has part numbers and I need to add a new column that assigns a % value to each distinct part number. 

For Example. 

part number A = 2%

part number B=4% 

Can any help me figure this out? Thanks!

Labels (1)
1 Reply
MatheusC
Specialist II
Specialist II

@Drece-gkn 

Do you want to bring how much (%) the number of pieces represents?
Imagining that's it, try the expression with the total  qualifier adapted to your model.

Count(distinct [field-parts])
/
Count (distinct total [field-parts])

Att,
Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!