6 Replies Latest reply: Jul 5, 2017 9:14 AM by Ivan Yang

# How to select data in measurement?

Dear QS Experts

I am new to Qlik Sense and I have a question about how to select data in measurement

I have a simple pivot table as below.

As each 'Sales No' may have more than one order line thus purpose of this pivot table is to calculate the order line of each 'Sales No'

Now I want to select 'Sales No' which order line quantity is more than 1, but I can't directly select them in measurement. May I know how to make it happen?

Ivan

• ###### Re: How to select data in measurement?

Hi lvan,

I think you can write in expression in that way:

Count({<SalesNO={'=Count(OrderNo)>1'}>}OrderNo)

Thanks,

Arvind Patil

• ###### Re: How to select data in measurement?

HI lvan,

Table1:

SalesNO, OrderNo

1, 11

1,12

2,21

2,22

3,31

4,41

5,51

5,52

5,53

];

Output:

Count({<SalesNO={'=Count(OrderNo)>1'}>}OrderNo)

Thanks,

Arvind Patil

• ###### Re: How to select data in measurement?

Patil

Thank you so much for you prompt request

I am sorry that I have another question accordingly

I create another measurement which simply minus 1 from the previous measurement

However, the total order line also simply minus 1 as well. The total sum order line of "N-1" should be 2776

May I know which part is wrong?

Ivan

• ###### Re: How to select data in measurement?

Hi Ivan,

If it is helpful for you then mark it .

Thanks,

Arvind Patil

• ###### Re: How to select data in measurement?

Hi lvan,

I hope it will help to solve your problem:

Count({<SalesNO={'=Count(OrderNo)>1'}>}OrderNo )-1

Try this:

Thanks,

Arvind Patil

• ###### Re: How to select data in measurement?

Patil