Re: Number format not giving correct results - Qlik Community

Adil-Haider · ‎2018-10-29

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')

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

dplr-rn · ‎2018-10-29

Can you share a sample app?

Whats the column type in data model for xyz and abc

sunny_talwar · ‎2018-10-29

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

achettipalli · ‎2018-10-29

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 · ‎2018-10-30

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.

Regards

Adil

sunny_talwar · ‎2018-10-30

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 · ‎2018-10-31

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 · ‎2018-10-31

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?