Discussion board where members can get started with Qlik Sense.
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.
Please help me..
Go to Solution.
Try like this in script, it is the best method
If(Nett < 0, 'Money Lending', 'Money Borrowing') AS [Money Market]
Are you trying to do it in the script or front end?
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?
Thank you Jagan...