topic Re: Minus im Skript in QlikView

Minus im Skript

Wed, 25 Nov 2020 16:16:04 GMT

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?

Laura

Re: Minus im Skript

Anonymous — Tue, 23 Aug 2016 14:02:09 GMT

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

Re: Minus im Skript

Tue, 23 Aug 2016 14:04:07 GMT

all positive

Re: Minus im Skript

Anil_Babu_Samineni — Tue, 23 Aug 2016 14:07:44 GMT

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

Re: Minus im Skript

trdandamudi — Tue, 23 Aug 2016 14:07:56 GMT

Can you please post a small sample...

Re: Minus im Skript

Anonymous — Tue, 23 Aug 2016 14:11:07 GMT

Okay

check this

'Cleared Volume' as Volumekey,

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

Re: Minus im Skript

Anil_Babu_Samineni — Tue, 23 Aug 2016 14:14:17 GMT

If this,

Please use

([Cleared Volume] - [Traded Volume])

Re: Minus im Skript

Tue, 23 Aug 2016 14:31:49 GMT

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

Re: Minus im Skript

Anonymous — Tue, 23 Aug 2016 14:36:58 GMT

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'

Re: Minus im Skript

Tue, 23 Aug 2016 14:52:39 GMT

same. still adding it

Re: Minus im Skript

Anonymous — Tue, 23 Aug 2016 15:03:09 GMT

we are not able to help you without a sample qvw or at least your script

as subtracting works well in Qlikview it must have todo with the content of your fields

Re: Minus im Skript

Tue, 23 Aug 2016 15:08:53 GMT

'Traded Volume'

as Volumekey,

'Cleared Volume' as Volumekey,

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

That is the part from my skript.

Re: Minus im Skript

Anonymous — Tue, 23 Aug 2016 15:20:24 GMT

I think Field names should be Unique within the table

'Traded Volume'

as Volumekey,

'Cleared Volume' as Volumekey2,

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

Re: Minus im Skript

Tue, 23 Aug 2016 15:25:21 GMT

I´ve allready try that. its unfortuantely not the problem

Re: Minus im Skript

Anonymous — Tue, 23 Aug 2016 15:28:06 GMT

one last thing before I give up without more information

try

Load *,

Volumekey - TradedVolume as [Give up/ Take up];

load

[Cleared Key] as Volumekey,

[Traded Key] as TradedVolume,

Re: Minus im Skript

Anil_Babu_Samineni — Tue, 23 Aug 2016 15:30:50 GMT

As I know,

Please take text object

Sum(Cleared Volume) - sum(Traded Volume) and see whether the values are coming or not.

Fabs(Sum(Cleared Volume) - sum(Traded Volume))

Note: I don't know what is the traded volume.