topic Re: values in graphic tabel in QlikView

values in graphic tabel

JACKNIEKERK — Fri, 15 Nov 2024 23:25:59 GMT

having a graphic table not showing values correct, how to solve

see attached please

tresB — Thu, 17 Dec 2020 09:22:16 GMT

Could you explain your expected output?

JACKNIEKERK — Thu, 17 Dec 2020 10:14:12 GMT

in the graphic table it has per customonmber like ASHA invoices foir a period

i would like to see in the top 10 table the highest sales by customer total sales for that period

looks like money wise this should be ASHA now it gives in money value wrong result

JACKNIEKERK — Thu, 17 Dec 2020 14:20:08 GMT

If i exclude negative values is load like

sql select * from mut05 where MutBoek='60' and MutRek = '1300' and MutBedrag > 1;

it shows ok, thats why i had in expression sum(MutBedragFak)> 1

that gives the error in display good graphics, in next test without this , and the other load it goes OK

but in fact all values should be in the calc to show real stats

JACKNIEKERK — Sat, 26 Dec 2020 09:41:51 GMT

Thus still have the problem that if I excluce credit sales , it works, but presentation wouild show wrong true values