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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Rehan
Creator III
Creator III

Measure Expresssion Issue

I am working on a Bar Chart with one dimension and 1 Expression. The expression is for both Dollar and Qty. There is a variable defined vToggle, 1  for dollar and 2 for Qty. My Expression is 

If(vToggle ='1',

Num(Sum(Sales),'$#,##0'),

Num(Count(Qty),'#,##0')),

Selected "Measure Expression" in Number format

I get the correct results but on y-axis I don't see a Dollar sign for Sum. 

What am I missing here.

2 Replies
JGMDataAnalysis
Creator III
Creator III

I assume the measure is fine.
In this case, I suggest you check the number formatting. It must be in "auto" (at least in Qlik Sense).

QlikCommunity_NumberFormatting_Auto.PNG

raghuchowdary
Contributor II
Contributor II

I think ,in this case the Number Formatting must be "Measure Expression" as the format is defined in the measure.

 

Please try this way, it works