topic Re: How to exclude records? in QlikView

How to exclude records?

Anonymous — Thu, 02 Mar 2017 16:21:43 GMT

Hi,

I have a pivot table that will display the number of orders and the items related to that order. for example order 10001 has 3 items10001-001, 10001-002 & 10001-003.

What I am trying to do is only displays the orders with more than 1 item related.

How can I do that?

Re: How to exclude records?

sunny_talwar — Thu, 02 Mar 2017 16:25:20 GMT

May be a calculated dimension like this

Aggr(If(Count(Item) > 0, Order), Order)

or a set analysis like this

Sum({<Order = {"=Count(Item) > 0"}>}Measure)

Re: How to exclude records?

Anonymous — Thu, 02 Mar 2017 17:28:31 GMT

Doesn't work, I need something like

Count (Order) / Count (item) >1

But if I expand it the total will be 1 and this won't work, am I right?

Re: How to exclude records?

sunny_talwar — Thu, 02 Mar 2017 17:29:57 GMT

May be this?

Sum({<Order = {"=Count (Order)/Count(Item) > 1"}>}Measure)

Re: How to exclude records?

Anonymous — Thu, 02 Mar 2017 18:12:36 GMT

Nope, if I use that function will show the table as blank, because when I expand a Order the total will change to 1 and I think it is failing 'cause of that.

Thank you for your effort.

Re: How to exclude records?

sunny_talwar — Thu, 02 Mar 2017 19:20:28 GMT

Would you be able to share a sample or some sample data or provide some more information in some way or the other?

Re: How to exclude records?

Anonymous — Thu, 02 Mar 2017 19:53:00 GMT

Unfortunately, I can't but when I sort by an expression the way that is filtered now worked.

Re: How to exclude records?

sunny_talwar — Thu, 02 Mar 2017 19:55:57 GMT

great