Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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])
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)
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
See the below table
you want to show all four condition in single column?
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
Yes
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])
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