Load distinct amount in details table - Qlik Community

vikasmahajan · ‎2012-12-24

Dear All

I have table invdet which has inv_docpayamt column this is total of header which is repetaing with details total

now i want to display only one time 65063 amt with details table , Whether this is possible in QV. I have attach

QV file also

Advance Thanks.

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

er_mohit · ‎2012-12-24

use distinct function might be helpful

like

sum(distinct inv_docpayamt)

hope it helps you

jagan · ‎2012-12-24

Hi Vikas,

Come up with an example output required, then it is easier to understand what you required, It is possible.

Regards,

Jagan.