Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Help with displaying results which are less than 9999

Hi,

I have a dimension in a PIVOT TABLE called 'EAN', EAN's are barcodes which range from 1 - 9999999999999. I only want numbers up to 9999 to be displayed within the EAN dimension, all numbers above 9999 i want to be excluded from the results.

Can someone tell me how to achieve this please?

Thanks

4 Replies
Miguel_Angel_Baeyens

Hello,

It should be as easy as using set analysis in all your expressions

Count({< EAN = {'<=9999'} >} DocumentNo)


Another workaround would be using an IF condition, which will affect your application performance.

Hope that helps

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

thanks for your reply, but what does DocumentNo mean??

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Actually that didn't seem to work. I don't want to count each time there is an instance of 9999 or below.

This is what i want to do...

If for example there are EAN's as below:

23

84

659

954

1002

5010358

5000256336224

5000687448574

9976568852472

I would only want the user to see the EAN's which are under 10000.

Miguel_Angel_Baeyens

Hi,

My sample above was just to show how set analysis works and how it should be used with your expressions. I was using "Count()" function based on a "DocumentNo" field and "EAN" field. It would be simpler if you post here an example of what you want to get and actual field names you are using.

On the other hand, if you are pulling info from the database and you mean you only want to get those EAN under 10000, a sample load statement would be

Table:LOAD Field1, Field2, EAN FROM DataSource WHERE EAN <= 10000;


Regards.