Qlik Community

Qlik Sense App Development

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

Partner
Partner

Money format auto sizing in qliksense: issue

hi community, 

anyone knows how to fix the problem of the money format auto sizing in qliksense?

For the number is super usefull setup the variable:

NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

--> using this variable, long numbers are automatically resized (E.g 1.098.890 --> 1,1 M)

But for the money format doesn't work (E.g 1.098.890 --> 1.098.890€). My wish is to have 1,1 M€

Really Thanks.

Paolo

 

Labels (3)
6 Replies
Employee
Employee

Re: Money format auto sizing in qliksense: issue

Change the environment variables at the beginning of the data load script to:
SET MoneyThousandSep=',';
Highlighted
Partner
Partner

Re: Money format auto sizing in qliksense: issue

ciao Lisa,

thanks for your reply. 

The point is not to change the MoneyThousandSep, Qliksense make auto sizing on the KPi Object, but the autosizing doesn't work with money. I try to explain the problem with an example as attachment.

The point 1. in the figure is just to show that the autosizing doesn't work with money format.

I would like to obtain the number explained in the  point 2. in the figure.

The issue is related to the object KPI, included in the qliksense native objects list.

 

Hope that is more clear now.

Thank you.

Paolo.

 

 

 

 

 

 

Employee
Employee

Re: Money format auto sizing in qliksense: issue

You can do this in your expression like this:
'Sales total: '&
If(Sum(Sales)<1000,Num(Sum(Sales),'##0€'),
If(Sum(Sales)<1000000,Num(Sum(Sales)/1000,'##0.00k€'),
If(Sum(Sales)<1000000000,Num(Sum(Sales)/1000000,'##0.00M€'),
Num(Sum(Sales)/1000000000,'##0.00G€'))))
etc
Partner
Partner

Re: Money format auto sizing in qliksense: issue

Hi Lisa.

thanks againg.

We would use a cleaned approach. Make expressions full of if mean bad performance.

We hope in other solutions.

Paolo

mato32188
Contributor III

Re: Money format auto sizing in qliksense: issue

Hi,

I have set variable to

SET NumericalAbbreviation='3:k€;6:M€;9:G€;12:T€;

with objections that I lost numerical format for other than money values in that app.

Martin

Partner
Partner

Re: Money format auto sizing in qliksense: issue

Thanks Mato

 

loose the normal format for other value is not possible.

 

Thanks