Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
dseelam
Creator II
Creator II

Different data formats in same column

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.

dseelam_2-1603295467721.png

 

 

Sorce data format

 

 

 

dseelam_1-1603295395369.png

Thanks,

D

Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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] 

View solution in original post

5 Replies
Anil_Babu_Samineni

Perhaps this?

Num(Num#(units * selling price))

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
dseelam
Creator II
Creator II
Author

Hello Anil, Thanks for reply,

But above solutions did not helps 

Thanks,

D

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Vegar
MVP
MVP

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] 

dseelam
Creator II
Creator II
Author

Thank you Vegar