Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Very new to Qlikview and this is my first question.
I am reading from a SAP SQL database and I have monetary values I need to use. These are all positive values and there is a seperate field with an indicator which identifies if the field is really a negative value.
I would normally write some code which would say the following:
IF SHKZG = 'H'.
WRBTR = 0 - WRTBR .
ENDIF.
Where SHKZG if the indicator field and WRBTR is the value field.
How do I do this in Qlikview, ideally in a scritp which would be saving to a QVD file for later use.
Thanks in anticipation.
Hi Paulw,
In the load script you could add something like:
LOAD
...
...
IF(SHKZG = 'H',0-WRTBR,WRTBR) as RealWRBTR,
.....
By doing this you will have a new field called RealWRBTR that has a negative value if the SHKZG is 'H' or has a positive value in all other cases.
Regards,
Joao
Hi Paulw,
In the load script you could add something like:
LOAD
...
...
IF(SHKZG = 'H',0-WRTBR,WRTBR) as RealWRBTR,
.....
By doing this you will have a new field called RealWRBTR that has a negative value if the SHKZG is 'H' or has a positive value in all other cases.
Regards,
Joao
Hi Jalmeida,
Many thanks for your quick response, it works perfectly.
Thanks again.
Regarda,
Paulw