Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
benwspx1
New Contributor III

Number Formatting Expression Works in PivotTable but not Line/Bar Chart

Howdy! This expression is included in my master item to return a number format based on certain conditions in the visual or selections. It works perfectly in my PivotTable but doesn't work at all in the line or bar chart. All charts have the measure set to "auto" number formatting.  However, when I replace the function with a standard format, such as '#,##0.0%', it works in the line & bar charts. Any ideas why my custom expression doesn't work in the line/bar chart but does in the pivottable?

clipboard_image_0.png

clipboard_image_1.png

 

clipboard_image_2.png

 

2 Replies
Employee
Employee

Re: Number Formatting Expression Works in PivotTable but not Line/Bar Chart

That might work ok for individual values for value labels, but there is only one y axis on these charts, so it can't change based on individual values.

benwspx1
New Contributor III

Re: Number Formatting Expression Works in PivotTable but not Line/Bar Chart

Lisa, 

I appreciate the quick response. In the bar or line chart, only one type ($ or %)  of values should be shown at any one time. $ and % will never be mixed but can be one or the other depending on what dimensions are included in the visual. Conditional statements within the measure determine what format encoding to return. Are you saying that bar/line type visuals are able to decipher those conditional formatting statements the same way the PivotTable does?