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

Exclusively Negative values in nested pie; outer pie ring (2nd dimension) doesn't appear

In the attached Qlikview, (with this data model):

LOAD * INLINE [

    Category, Subcategory, Value, PosOrNeg

    Fruit, Apple, 3, Positive

    Fruit, Banana, -2, Negative

    Vegetable, Carrot, 3, Positive

    Vegetable, Pea, 1, Positive

    Vegetable, Tomato, -5, Negative

];

I want to analyze exclusively positive values, so filter on "Positive"

(I also may ignore Peas so I only have Apples and Carrots)

Either way, I can see outer pie ring on the lower-right.

positive inner pies will work.PNG

But when I filter on exclusively Negative values, I can no longer see the outer pie ring on the lower-right:

negative innner pies dont work.PNG]

I can understand why these things don't support both positive and negative values.

And I know Block charts can't render when values are negative even if a single-level pie chart does work.

But must I accept that a nested pie won't work?

I guess a workaround is to wrap in FABS()?

0 Replies