topic positive, negative and greater than values in App Development

positive, negative and greater than values

Naresh1 — Mon, 27 Jan 2020 10:08:20 GMT

Hi,

I have Lot of fields in qliksense table, using two fields in qliksense table those are outstanding amount and original amount, some values are common in these two fields, my client given some conditions for these two fields

1. Original Amount = Outstanding Amount (Positive Amount)
2. If Outstanding Amount is Less than Original Amount (Positive amount) 3. If Outstanding Amount is greater than or Equal To Original Amount (Negative amount)

all these conditions should come in qliksense table order wise, how can i do this?

its urgent

Thanks

Re: positive, negative and greater than values

TimvB — Mon, 27 Jan 2020 11:23:38 GMT

Set in the sort section of the Table the sort function to "Expression" and paste the following sort function:

if([Original Amount] = [Outstanding Amount], '1', If([Original Amount] > [Outstanding Amount], '2','3' ))

You can do this in the script as well and use the function Dual instead.

Re: positive, negative and greater than values

Naresh1 — Tue, 28 Jan 2020 03:58:46 GMT

Hi,

See the below sample data

And also I'm given conditions,

I want to do all the conditions in Qliksense table,

See 4 conditions,

I want all 4 conditions values should come order by,

Thanks for responding