Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
Nari999
Partner
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
UserID2626
Creator II
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])

Nari999
Partner
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)

UserID2626
Creator II
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

Naresh1
Contributor III
Contributor III

See the below table

UserID2626
Creator II
Creator II

you want to show all four condition in single column?

Nari999
Partner
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

Naresh1
Contributor III
Contributor III

Yes

UserID2626
Creator II
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])

 

Nari999
Partner
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