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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-05-02 12:13 PM

Trellis Chart Question

Hello community,

I have errors (e.g. F1, F2) and error types( T1,T3 for error F1) (see attached qvw).

I'm trying to show the top X errortypes per error in a trellis chart.

Can someone tell me how to implement this (At the moment I get all types for each errror?


Thanks in advance.

Kind regards

Aloah

Test.qvw
7,567 Views
0 Likes
1 Reply
Not applicable
‎2011-05-02 04:18 PM
Author

I found other related post with the same problem and no solution. So I think I have to set this up with separate bar charts.
Can someone help me how the formula must look like to get top 10 error types per error. Thanks in advance.

Tried with a dynamic dimension: =if(rank(aggr( sum( Amount ), Error ))=1, Type) for top 1 error and related types

but this is unfortunately not working


Aloah

161 Views
0 Likes