topic Filtering the data to be displayed! in QlikView

Filtering the data to be displayed!

Sat, 28 Nov 2009 14:52:01 GMT

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

Sat, 28 Nov 2009 15:06:45 GMT

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

Sat, 28 Nov 2009 16:10:16 GMT

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

Sat, 28 Nov 2009 21:34:44 GMT

I believe dragonauta's suggestion should work

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

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

Mon, 30 Nov 2009 21:40:27 GMT

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.

Tue, 01 Dec 2009 11:46:28 GMT

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.

Wed, 02 Dec 2009 13:35:23 GMT

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.

Wed, 02 Dec 2009 15:32:54 GMT

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