Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

negative and positive values

hi Friends,

 

i have a calculated field Nett, using that i would like to show in my chart as ,

if Nett is -ve, it should be Money Lending , +ve means Money Borrowing and these two should come under in single column Money Market.

NettMoney Market
    (1,622)Money Lending
     5,297 Money Borrowing
    12,373 Money Borrowing

Please help me..

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this in script, it is the best method

LOAD

*,

If(Nett < 0, 'Money Lending', 'Money Borrowing') AS [Money Market]

FROM Datasource;

Regards,

jagan.

View solution in original post

4 Replies
sunny_talwar

Are you trying to do it in the script or front end?

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this in script, it is the best method

LOAD

*,

If(Nett < 0, 'Money Lending', 'Money Borrowing') AS [Money Market]

FROM Datasource;

Regards,

jagan.

Anonymous
Not applicable
Author

What exactly you want??

If you want to create a new field like Money Market, the best we can do at script level is what Jagan have already suggested..

Let us know if it is sort out your issue?

Not applicable
Author

Thank you Jagan...