Minus im Skript - Qlik Community

Report Inappropriate Content · ‎2016-08-23

Hallo zusammen,

ich möchte meine Traded Werte von meinen Cleared Werten Abziehen und schreibe im Skript folgendes.

'Cleared Volume' as Volumekey,

'Cleared Volume -Traded Volume' as [Give up/ Take up],

Leider Addiert er anstatt zu subtrahieren.

Weiss einer woran das liegt?

VG

Laura

Anonymous · ‎2016-08-23

Hi

check if there are any Negative values in "Traded Volume" ?

Report Inappropriate Content · ‎2016-08-23

all positive

Anil_Babu_Samineni · ‎2016-08-23

Can you try to post in English, please take help to covert

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

trdandamudi · ‎2016-08-23

Can you please post a small sample...

Anonymous · ‎2016-08-23

Okay

check this

'Cleared Volume' as Volumekey,

(Cleared Volume -Traded Volume) as [Give up/ Take up],

Anil_Babu_Samineni · ‎2016-08-23

If this,

Please use

([Cleared Volume] - [Traded Volume])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Report Inappropriate Content · ‎2016-08-23

unfortuantely no, still count it together and not "-"

Anonymous · ‎2016-08-23

can you post complet part of your script with sample data?

does 'Cleared Volume' and [Give up/ Take up] contain the same value per row?

what happens when you add the fields? 'Cleared Volume' + ' 'Traded Volume'

Report Inappropriate Content · ‎2016-08-23

same. still adding it