Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Adil-Haider
Contributor III
Contributor III

Number format not giving correct results

Hi All,

Hope you all are fine.

I need help with one of the number format issue. The MIN formatted and MAX  formatted column shown are calculated as below:

num(avg(xyz),'#,##0.0')

num(avg(abc),'#,##0.0')

issue.PNG

However when i export this actual values are MIN and MAX in excel.

I want to achieve the values in the MIN used_calculation and MAX used_calculation as MIN formatted and MAX formatted so that my calculations are correct in excel. I have tried Floor, Ceil and Round function but none of them are giving the results in the formatted columns MIN formatted and MAX formatted.

Any help would be appreciated.

Regards

Adil

7 Replies
dplr-rn
Partner - Master III
Partner - Master III

Can you share a sample app?

Whats the column type in data model for xyz and abc

sunny_talwar

Have you tried setting the formatting from the Number's tab?

achettipalli
Creator
Creator

Hi Adil,

Num() doesn't store its value in its format. it's just to display.

1.You can work through 'Number' tab in the chart or through 'Number' tab in document properties.

2. try Round(Expression,0.1)


Good luck!

Avinash

Adil-Haider
Contributor III
Contributor III
Author

Hi Avinash,

1st option is not feasible as i need to use the result in calculation.

I had already tried 2nd option but it gives 0.9 for 0.85 and 0.8 for 0.75.

Moreover i am wondering how num(MIN(xyz),'#,##0.0') is giving this value shown in AT MIN formatted column.


issue.PNG


Regards

Adil

sunny_talwar

1st option is not feasible as i need to use the result in calculation.

Would you be able to elaborate on this? Why is not feasible?

Adil-Haider
Contributor III
Contributor III
Author

Hi Sunny,

The result which is shown by Num() function, i need similar kind of result for calculation in another column. but i am not sure if at all Num() function is giving the correct result in the first place.

Since i have to use the result, Number formatting wont help in that case.

Thanks

Adil

sunny_talwar

I am still not sure why you are not able to use formatting on the number tab... would you be able to share a sample which can show us the issue you are running into when you use formatting on the number's tab?