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: 
Not applicable

Formatting issue with dimension value "others"

Hey guys,

I am experiencing a strange behaviour by QlikView.

In order to show only the higher value shares in a pie chart, I set the lower limit in the "Presentation" tab of the pie chart to 0.1.

So as I wanted, QV aggregates the shares of <10% to the value "others".

But exactly for this artificial value "others", the standard expression format seems to be ignored...

This was the format before the change:

screenshot.165.png

This is what I get when I change the lower limit of the presentation:

screenshot.166.png

Note that only the value "Others" has a different format, the other values are still fine!

In the "Number" tab of the pie chart I have selected "Expression default".

This is my expression with the number format:

num(     count(          {$<UWY = {   $(=max(UWY))      }  > }   distinct VTGNR         )          /      count (          {$<UWY = {   $(=max(UWY))      }  > }   total distinct VTGNR          ) , '#'&chr(39)&'##0.0%', '.' , chr(39))

Please note:

Is is not an option for me to override the expression default by any other setting in the "Number" tab, because I change the used expression by a variable and sometimes different number formats apply, which are only defined by the expression itself, controlled by variables.

I hope I made my problem clear and easy to grasp.

Thanks in advance for any help!

0 Replies