Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Minus im Skript

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

15 Replies
Anonymous
Not applicable
Author

Hi

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

Not applicable
Author

all positive

Anil_Babu_Samineni

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
Master II
Master II

Can you please post a small sample...

Anonymous
Not applicable
Author

Okay

check this

'Cleared Volume'    as Volumekey,

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

Anil_Babu_Samineni

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
Not applicable
Author

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

Anonymous
Not applicable
Author

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'

Not applicable
Author

same. still adding it