topic Re: Number format issue between qlikview 11 and qlikview 12 in QlikView

Number format issue between qlikview 11 and qlikview 12

NirmalaKumari — Wed, 25 Nov 2020 16:16:04 GMT

Number format issue in qlikview 12 when chart expression uses ‘Set Analysis expression’.

Expression: =Sum({<DATE={$(='"' & (vLatestDate) & '"')}>}Aggr(Sum(STAT_COUNT_SUBSCRIBER),DATE,STAT_INS_SERVICE_NAME))

qlikview 11 value is shown as : 48766383

same file when opened in qlikview 12 displays values like 48.766383

Please help to fix same.

Re: Number format issue between qlikview 11 and qlikview 12

Chanty4u — Tue, 27 Oct 2020 09:02:38 GMT

Not sure, but similar case. can you try below links.

https://community.qlik.com/t5/QlikView-App-Development/Did-QV-s-default-number-format-change-in-12-40-April-2019/td-p/1590606

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Number-formatting-in-document-properties/td-p/1293816

Re: Number format issue between qlikview 11 and qlikview 12

Brett_Bleess — Wed, 04 Nov 2020 21:38:45 GMT

@NirmalaKumari You need to be sure you have read all the Release Notes between 11.20 and the version of 12 you upgraded to, as there have been changes in many features of the product, and I suspect the quoting in Set Analysis is what you have run into here.

Here is a Design Blog post that may help though:

https://community.qlik.com/t5/Qlik-Design-Blog/Quotes-in-Set-Analysis/ba-p/1471824

Likely need a sample app that shows the issue otherwise, but in this case if you have something you can repeat, it might be better to submit a support case to get it looked into that way. I am not sure what else it may be related to off the top of my head, and this does not ring a bell either, but if you did not check Release Notes for each interim track, I would go back and do that, or check the What's New in the Help for those releases. Sorry I do not have something better.

Regards,
Brett

Re: Number format issue between qlikview 11 and qlikview 12

Brett_Bleess — Wed, 04 Nov 2020 21:39:24 GMT

One other thing, it may just be something in the chart as well, you may want to try to recreate the chart in the new release, that may do the trick on this one too potentially.

Regards,
Brett