certain user see KPI numbers with periods instead of commas

[vvira1316]

Hi,

I just noticed that certain user see KPI number that I've formatted to be seen using commas are seeing with period instead...

Please see the screen shot from user.....

This should be seen as below....

Formula for each of them has something like following....

=Num(Count(ID) ,'###,###,###')

Any idea why certain user will see it with period (52.435 instead of 52,435 for first KPI)

[swuehl]

Interesting, QFC Terms seems to still be formatted correct?

Not sure why you see this issue (only for one user?), but maybe try with explicite stating the decimal and thousand separator:

=Num(Count(ID) ,'###,###,###','.',',')

[vvira1316]

Hi Stefan,

Thanks for your reply. I'll try and check it out. I'll update information once I review with the user.

Regards,

Vijay

[swuehl]

Which client (Ajax, Plugin or Desktop) is the user using?

I would also suggest to check the system settings for number presentation on his computer (does it differ from your default setting), and since the formatting differs for QFC Terms, it might be helpful to compare the expressions / formatting options for the different KPI.

[rubenmarin]

Hi Vijay, I think that to use Num the number format of the measure should be 'Auto', maybe it's fixed as integer without decimals and it's using the numeric format of the system/browser?

[vvira1316]

Hi,

We have two servers (UAT and PROD). The users are accessing the dashboard from Access Point for each one of them.

Following behavior is from accessing dashboard on Portal of each environment.

I've one user for whom it is showing decimals in UAT but not in PROD.

I've another user it showing decimals in both UAT and PROD.

I've one more user (besides me) for whom UAT and PROD both are showing correct with COMMAS.

So it is so strange behavior that I don't understand what is the issue. How do I check settings in their system, or in QlikView files or on QV server.

KPIs are showing Numbers on a text object using following formulas

KPI#1

=Num(Count({<
[Document Status]={'Execution Docs Complete*'},
[Global Document Type]*={'ISDA','MRA', 'GMSLA', 'Exchange Agreement', 'Selling Guide', 'Priority Credit Line Agreement', 'General Account Agreement', 'MSFTA','GMRA','MSLA','NAESB','Foreign Exchange Master Agreement','Margin Lending Agreement','Prime Brokerage Agreement','Term Commitment Annex','Futures and Cleared Swaps Agreement','ISDA CREDIT SUPPORT ANNEX'}*p([Agreement Document Type]),
[Agreement Document Type]=
>}[Counterparty Document: Document ID])
,'###,###,###','.',',')

KPI#2

=Num(Count({<
[Version]={'>0'},
[Agreement Terms: Document Status]={'Execution Docs Complete*','Completed in Markit*'}
>}
[Agreement Terms: SFDC Credit Terms New number]),'###,###,###','.',',')

KPI#3

=Num(Count({<
[Version]={'>0'},
[Agreement Terms: Document Status]={'Execution Docs Complete*','Completed in Markit*'}
>}Aggr(RowNo(TOTAL), [Agreement Terms: SFDC Credit Terms New number], [API Name], ColValues)), '###,###,###','.',',')

KPI#4

=Num(Count({<
[Version]={'>0'},
[Agreement Terms: Document Status]={'Execution Docs Complete*','Completed in Markit*'}
>}Aggr(RowNo(TOTAL), [Agreement Terms: SFDC Credit Terms New number], [API Name], ColValues, [Picklist Value])), '###,###,###','.',',')

KPI#5

=Num(Count({<
[Version]={'>0'},
[Agreement Terms: Document Status]={'Execution Docs Complete*','Completed in Markit*'}
>}Aggr(RowNo(TOTAL), [Agreement Terms: SFDC Credit Terms New number], [BAId CPTY Doc Junction])), '###,###,###','.',',')

[rwunderlich]

Question: For those users seeing decimal for separator, is there machine set for a region (like Europe) that uses decimal as thousands separator?

It doesn't explain what you are seeing, but your formatting mask is unusual to me. I've never used a second comma in the mask. I always use just one comma and one digit to the left of the comma:  "#,###'.  That handles thousands, millions, billions etc inserting commas as necessary. .

Further I always use 0 as the rightmost digit, not "#". i.e.  "#,##0".  Otherwise large numbers tend to get displayed in exponential notation.

I wonder how your KPIs will look if you used the more "standard" "#,##0" ?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[vvira1316]

just found out that it is happening only IE Plugin Portal Access. Full browser version is rendering commas for all KPIs. Also one more issue that we noticed was in bar chart dimension labels... the screen shot of it is below. The dimension labels were cluttered in IE Plugin version but not so much in Full Browser version Not sure if it is happening because of chart window size.

Cluttered IE Plugin version screen shot

Full Browser version screen shot....

I see small misalignment in second chart but not in first one....

[vvira1316]

Hi Rob,

Thanks for your input. I changed it as per your suggestion "#,##0" but it is still showing up with period for some of the KPIs. Not sure why one of the KPI shows correctly with comma even though same formatting is used for all of them. Also computer settings were to cause it than it should have done across all KPIs (we have one that is displaying correctly.

Another issue that I'm having in IE Plugin version is dimension label misalignment for the bar chart as it can be seen from screen shot.

I'll be trying to uncheck Show All Bars and Thin Bars in Presentation tab of Bar Chart. For formatting I'll just do '#,##0.' and remove ,'.',',' from    =Num(Count(ID) ,'###,###,###','.',',')     to see if that will help

[rwunderlich]

Does IE Plugin version match Server version?

-Rob