Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
robertocesp
Contributor II

How to exclude records?

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?

Tags (1)
7 Replies

Re: How to exclude records?

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)

robertocesp
Contributor II

Re: How to exclude records?

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?

May be this?

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

robertocesp
Contributor II

Re: How to exclude records?

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?

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

robertocesp
Contributor II

Re: How to exclude records?

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

Re: How to exclude records?

great