topic Re: Different data formats in same column in QlikView

Different data formats in same column

dseelam — Mon, 26 Jan 2026 18:19:17 GMT

Hello All,

I am trying to achieve units * selling price as total amount seems its working fine for selling price 17.99 which is a text format but not working for 7.22 showing as $0, Not sure what to do used num(), num#() not working please help.

Sorce data format

Thanks,

Re: Different data formats in same column

Anil_Babu_Samineni — Wed, 21 Oct 2020 15:55:41 GMT

Perhaps this?

Num(Num#(units * selling price))

Normally, Qlik calculates over dimension with aggregate, Perhaps this way

Num(Num#(Sum(units * selling price)))

Re: Different data formats in same column

dseelam — Wed, 21 Oct 2020 16:25:41 GMT

Hello Anil, Thanks for reply,

But above solutions did not helps

Thanks,

Re: Different data formats in same column

Anil_Babu_Samineni — Wed, 21 Oct 2020 16:30:20 GMT

Can you please share sample Qlik file which demonstrate quicker for you?

Re: Different data formats in same column

Vegar — Wed, 21 Oct 2020 16:32:30 GMT

Try wrapping a trim() around selling price. Sometimes that helps if there are some invisible whitespace in the source data.

Trim(SELLING_PRICE) AS [Selling Price]

Re: Different data formats in same column

dseelam — Wed, 21 Oct 2020 16:49:19 GMT

Thank you Vegar