Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
JACKNIEKERK
Creator
Creator

values in graphic tabel

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

see attached please

 

Labels (2)
4 Replies
tresesco
MVP
MVP

@JACKNIEKERK 

Could you explain your expected output?

JACKNIEKERK
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

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