Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: negative and positive values

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.

4 Replies
MVP
MVP

Re: negative and positive values

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

MVP
MVP

Re: negative and positive values

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.

balrajahlawat
Esteemed Contributor

Re: negative and positive values

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

Re: negative and positive values

Thank you Jagan...