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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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