topic Measure Expresssion Issue in App Development

Measure Expresssion Issue

Rehan — Fri, 25 Oct 2019 16:00:49 GMT

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.

Re: Measure Expresssion Issue

JGMDataAnalysis — Fri, 25 Oct 2019 21:36:14 GMT

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).

Re: Measure Expresssion Issue

raghuchowdary — Fri, 25 Oct 2019 23:04:13 GMT

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