Some row unable to display the amount ?

[#1]

Hi All

I have only one excel file , after loading in the raw data to QV , some of the row , unable to display the amount.

I already add trim and num before load the raw data in :-

Num(trim([COST PRICE]))*(1-[Discount])

Paul

[vikasmahajan]

NUM(TRIM([Distributor Discount]),' #,##0.00') as [LIST_PRICE]

Try this

[tresesco · Accepted solution]

Because for those rows (with that selection), there are multiple values for the columns (FOB_SGD_SUB, FOB_PRICE_SUB). In such scenarios you have to use some aggregation function like:

Sum(FOB_SGD_SUB),

Sum(FOB_PRICE_SUB)

Note: While you use the field name alone, the value can be shown only if there is only one value against that POV.

[#4]

Hi Paul,

Multiple values are available in the columns "FOB_Price_SGD" & "FOB_SGD_SUB" for one Part_No_

You need to use some aggregation function in such cases to get the value displayed Eg. SUM

Hope this helps.

[#5]

Hi Shy

I have try to read  more then 40 excel price list. All with out any issue except this product group.

So I think the problem is on the source. Any way I will try all suggestions later on. 

Thank you for sharing.

Paul Yeo

+6593261804

Skype paulyeo_thai

[#6]

Hi All

Many thank for all your contribution , yes it work after add sum in front. i never expect this work.

Paul

[#7]

Hi Vikas

I try your propose load script to force raw value into 2 digit decimal point. But i am not able achieve it , kindly look at below link :-

http://community.qlik.com/message/385394#385394