# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for
Did you mean:
Partner

## Qliksense table fields values

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

is it possible?

Thanks,

9 Replies
Creator II
1. original amount = outstanding amount (positive amount), voucher type other than payment

Sum({<[Voucher Type]-={‘Payment’},[ Voucher Type]={"=sum([Out Standing Amount])>0)" } >}[Original Amount])

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

Sum({<[Voucher Type]={"=sum([Out Standing Amount])<Sum([Original Amount))" } >}[Original Amount])

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

Sum({<[Voucher Type]={‘Payment’},[ Voucher Type]={"=sum([Out Standing Amount])>0)" } >}[Original Amount])

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

Sum({<[Voucher Type]={"=sum([Out Standing Amount])>=Sum([Original Amount))" } >}[Original Amount])

Partner
Author

values or not coming correctly and also all these values i want to show in original amount and outstanding amount fields using voucher date, i want values order by like these , all should be in one table

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)

first condition equal values should come first and voucher type other than payment(positive amount )

second condition outstanding amount less than original(positive)

third condition original = outstanding (voucher type payment)

firth condition outstanding >=  original (negative amount)

Creator II

1. original amount = outstanding amount (positive amount), voucher type other than payment
Sum({<[Voucher Type]-={‘Payment’},[Voucher date]={"=sum([Out Standing Amount])=Sum([Original Amount])"},[Voucher date]={"=Sum([Original Amount])>0" } >}[Measure_Field])

2.outstanding amount less than original amount (positive amount)
Sum({<[Voucher date]={"=sum([Out Standing Amount])<Sum([Original Amount])"},[Voucher date]={"=Sum([Original Amount])>0" } >}[Measure_Field])

3. original amount = outstanding amount (positive amount), voucher type payment
Sum({<[Voucher Type]={‘Payment’},[Voucher date]={"=sum([Out Standing Amount])=Sum([Original Amount])"},[Voucher date]={"=Sum([Original Amount])>0" } >}[Measure_Field])

4. outstanding amount greater than or equal to original amount (negative amount)
Sum({[Voucher date]={"=sum([Out Standing Amount])>=Sum([Original Amount])"},[Voucher date]={"=Sum([Original Amount])<0" } >}[Measure_Field])

change measure_field to original or outstanding as per ur requirement

Contributor III

See the below table

Creator II

you want to show all four condition in single column?

Partner
Author

Please see the below excel table, in my excel that type of fields are there, please see the conditions field, i think you should understand

Contributor III

Yes

Creator II

Sum({<[Voucher Type]={"=sum([Out Standing Amount])=Sum([Original Amount])","=sum([Out Standing Amount])<Sum([Original Amount])","=sum([Out Standing Amount])>=Sum([Original Amount])"} >}[Measure_Field])

Partner
Author

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

all fields in excel table also having in base table, i dont need condition field, i want to apply that conditions to these fields only like original amount, outstanding amount, voucher type

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

Tags
Community Browser