Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Re: Sum in straight table

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

4 Replies

Re: Sum in straight table

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

rajkumarb
Contributor II

Re: Sum in straight table

HI Ahmad

Try this in Expression in Straight Table

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

MVP
MVP

Re: Sum in straight table

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

Re: Sum in straight table

Yes Raj ,

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

thank you