topic Re: Thousands separator in class function in QlikView

Thousands separator in class function

Pandatin09 — Fri, 19 Feb 2021 07:20:14 GMT

I am having issues getting the thousands separator to appear in the class function for the bin, I currently have the dimension set as this calculated field and i would like the bin values to include the thousands separator

=text('$ '&dual(replace(class([Notional Amount in USD],vNotionalBin),'<= x <','- $'),class([Notional Amount in USD],vNotionalBin)))

The vNotionalBin is the user variable that they can input to adjust the binning of this dimension to further drill down or to zoom out.

and count of another variable for my expressions tab which works fine.

Re: Thousands separator in class function

MarcoWedel — Fri, 19 Feb 2021 09:46:08 GMT

You could instead format your upper and lower bin amounts using the propper Money() function and concatenate the limits.
To get a numerical value as well you then apply the Dual() function like you already did and skip the text() function because that would delete the numerical part you just before created with Dual().

So one solution could be:

Dual(Money(Floor([Notional Amount in USD],vNotionalBin))&' - '&Money(Floor([Notional Amount in USD],vNotionalBin)+vNotionalBin),Floor([Notional Amount in USD],vNotionalBin))

Re: Thousands separator in class function

Pandatin09 — Mon, 22 Feb 2021 02:31:42 GMT

Thank you Marco, your solution managed to replicate the class function and display the values in the format that i would prefer.

Re: Thousands separator in class function

MarcoWedel — Wed, 03 Mar 2021 15:03:19 GMT

you're welcome.
Glad it helped