Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum in straight table

Dears ,

Good day , and i hope everyone in good health ,can you find the attached Pic .

i need to do sum on column where the column equal a specific value like what i attached ,

any idea . 

1 Solution

Accepted Solutions
robert_mika
Master III
Master III

=SUM({<[Rent Type]={'RL'}>} Debtor)

View solution in original post

4 Replies
robert_mika
Master III
Master III

=SUM({<[Rent Type]={'RL'}>} Debtor)

rajkumarb
Creator II
Creator II

HI Ahmad

Try this in Expression in Straight Table

sum(if(Rent Type<>'RD', Sum Field))

petter
Partner - Champion III
Partner - Champion III

You could also jusr simply click iæon the cell with the RL value and it will only show those. Or you could add a list box for the rent type and click on RL in the list box....

Not applicable
Author

Yes Raj ,

Thank you for Replay , but i try this but because i have more than two values RD,RL,RM....

thank you