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: 
Anonymous
Not applicable

straight table total

Hi Guys,

I am posting an application here,I have created a straight table where I want the sum of total freight grouped by Inv no and LB-Business division hence for the Inv no I have selected  INI1431006190

the sum column should be

sum

2887(total)

1887

1887

1887

1000

why it is giving me 3779?it should be 1887

1887(629+629+629) because the Inv no and LB-Business Unit are same.

Please help..Urgent requirement

!

3 Replies
m_woolf
Master II
Master II

When I make a list box with check and show the frequency, I get:check freq.png

You might look at your data to see why checks 3567, 68,69 are in twice.

Gysbert_Wassenaar

You have duplicate data somewhere. Try this expression:

=sum(total <[LB-Business Division], [Inv. No.]> aggr(max( [Total Freight]), [LB-Business Division], [Inv. No.],check))


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

I made a blunder there...thnx guys..