Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ben_2019
Contributor
Contributor

How to group/ #Pareto chart/ #dimension

Hello everybody!

First at all, thank you to everyone that help me!.

I need to make a Pareto chart, but the values that I have are millions and I don't know to manage them. I made it but in "Expressions" because I do not know to group all the tests in one "Tests_ED" by example, or whatever. That case is, when I made it by Expressions  It's not avalible to create a Pareto.

The tablesource is something like that:

#/ Serienummer/ Time/ Status /Article/ Line/ Öffnungdruck/ uevschliesdruck/...

Status: Values are "IO" or "NIO"

  IMPORTANT:  Status shows when IO or NIO is, but I need to calculate just when NIO is.

Öffnungdruck  and all tests : Values are Numbers like "16,93"

grafik.png

 Bar chart that I get working with expressions. It is good but 'till not represent what i need

grafik.png

 

 

 

S. Each test depends on the previous.

Anyone can help me! Thanks a lot for any idea.

 

 

2 Replies
Gysbert_Wassenaar

Can you post a small Qlikview document with some example data that explains what you're trying to do?


talk is cheap, supply exceeds demand
Ben_2019
Contributor
Contributor
Author

Sure. here its

Thanks