Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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
Specialist

@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!