Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering the data to be displayed!

I wanted to display only those records in which recentitem=1. How can i do that using set analysis.

error loading image

7 Replies
Not applicable
Author

sum({<recentitem={1}>} MRP)

Not applicable
Author

I want to display on those items with their MRP where recentitem=1

Not applicable
Author

I believe dragonauta's suggestion should work

=sum( {$<recentitem= {1}>} MRP )

This will only show the sum of MRP for records with recentitem=1

Not applicable
Author

I think dsjain has defined recentitem as sum(recentitem); there is a sum-line above.

On the Presentation sheet, there's a Suppress Zero-Values. Mark that, and the records with recentitem=0 will not show.

Not applicable
Author

This is what i have defined in the expression.

This is what i have defined in the expression.

column 1

=sum({$<recentitem={1}>} MRP)

column 2

MRP

and by the way Suppress Zero-Values has been already marked. Let me know is whether there is anyother solution for this.

Not applicable
Author

This should work:

Column1

recentitem

Column 2

Sum({$<recentitem={1}>}MRP)

Supress zero values must be checked

It seems you don't actually want to sum value s- in this case select "No totals" in the Total mode (expressions tab) of the sdtraight table.

Not applicable
Author

And why have Resentitem as a expression. Use it as a Dimension. Then you dont have to worry about totals.