topic Re: Qliksense table fields values equal, positive, negative in App Development

Qliksense table fields values equal, positive, negative

Naresh1 — Tue, 28 Jan 2020 06:18:52 GMT

Hi,

I have three fields in qliksense table in those three fields names are voucher type, original amount, outstanding amount,

outstanding amount and original amount fields having some common values negative, positive and equal values

they given 4 conditions for these

1. original amount = outstanding amount (positive amount), voucher type other than payment

2.outstanding amount less than original amount (positive amount)

3. original amount = outstanding amount (positive amount), voucher type payment

4. outstanding amount greater than or equal to original amount (negative amount)

all these conditions i want to show in qliksense table

previously i am posted few questions, i got answers from them with in day

but this one question, i dont get any answer,is it possible?

Thanks,

Re: Qliksense table fields values equal, positive, negative

Vegar — Tue, 28 Jan 2020 07:57:45 GMT

I found it hard to understand all your definition without a sample and a desired output, but I'm guessing that the correct expression for no 1. is the following.

=Sum({<[voucher type]={"= [voucher type]<> 'Payment'"}>}[original amount])

Could you create a sample similar to this and also what's the desired output for the four expression on that dataset? It will make it easier to help you with the rest.

Sample: LOAD * inline [ Voucher type, Original amount,Outstanding amount Payment, 1000, 1000 Credit, -3000, 0 Bank , -3000, -1000 ];

Re: Qliksense table fields values equal, positive, negative

Naresh1 — Tue, 28 Jan 2020 08:08:01 GMT

Please see the below sample excel table

Same This table i want to load in Qliksense

And also given conditions order wise how the values should come

Re: Qliksense table fields values equal, positive, negative

Vegar — Tue, 28 Jan 2020 08:56:49 GMT

I did not really understand your excel either, I tried to restructure it? Is it correct? Please adjust and add info on what you are expecting for output.

Re: Qliksense table fields values equal, positive, negative

Naresh1 — Tue, 28 Jan 2020 09:39:02 GMT

see the below excel table

Re: Qliksense table fields values equal, positive, negative

Vegar — Tue, 28 Jan 2020 10:03:47 GMT

Take a look at my output and expression below. Notice the colored line that do get any classification as it does not meet any condition

DATA: LOAD *, IF( [voucher type] = 'other than payment' and [original amount]=[outstanding amount] AND [original amount]>=0, 1, IF( [voucher type] = 'payment' and [original amount]=[outstanding amount] AND [original amount]>=0, 4, IF( [original amount]>=[outstanding amount] AND [original amount]<0, 3, IF( [original amount]>[outstanding amount] AND [original amount]>=0, 2, 0 ) ) ) ) as Class; LOAD * inline [ voucher type original amount outstanding amount Condition? other than payment 20000 20000 1. original amount = outstanding amount (positive amount), voucher type other than payment other than payment 10 10 1. original amount = outstanding amount (positive amount), voucher type other than payment payment 3000 24000 2.outstanding amount less than original amount (positive amount) payment 2300 2100 2.outstanding amount less than original amount (positive amount) payment -890 -890 3. outstanding amount greater than or equal to original amount (negative amount) other payment -200 -300 3. outstanding amount greater than or equal to original amount (negative amount) payment 600 600 4. original amount = outstanding amount (positive amount), voucher type payment payment 7800 7800 4. original amount = outstanding amount (positive amount), voucher type payment ] (delimiter is ' ');

Re: Qliksense table fields values equal, positive, negative

Naresh1 — Tue, 28 Jan 2020 10:09:26 GMT

Sorry, its not 3000 , its 30000 thanks for your response

Re: Qliksense table fields values equal, positive, negative

Naresh1 — Wed, 29 Jan 2020 05:28:15 GMT

Hi Vegar,

I am loaded base table in database to qliksense, i want output exactly like in below excel table to qliksense table

in base table having all fields like excel,

but i dont need conditional field in qliksense

i want only that conditions should apply to this fields only 'original amount', 'outstanding amount', 'voucher type'

in voucher type having credit, debit, voucher, receipts, other payment