topic Re: Number format not giving correct results in QlikView

Number format not giving correct results

Adil-Haider — Mon, 29 Oct 2018 13:01:42 GMT

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

Re: Number format not giving correct results

dplr-rn — Mon, 29 Oct 2018 13:25:10 GMT

Can you share a sample app?

Whats the column type in data model for xyz and abc

Re: Number format not giving correct results

sunny_talwar — Mon, 29 Oct 2018 13:27:04 GMT

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

Re: Number format not giving correct results

achettipalli — Mon, 29 Oct 2018 13:28:34 GMT

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

Re: Number format not giving correct results

Adil-Haider — Tue, 30 Oct 2018 06:19:49 GMT

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

Re: Number format not giving correct results

sunny_talwar — Tue, 30 Oct 2018 10:31:18 GMT

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?

Re: Number format not giving correct results

Adil-Haider — Wed, 31 Oct 2018 04:11:36 GMT

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

Re: Number format not giving correct results

sunny_talwar — Wed, 31 Oct 2018 11:05:47 GMT

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?