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: 
Not applicable

New to Qlik Sense, Need help with filtering function

I am trying to achieve 3 items based on filtering:

  1. 1. Work with Filtering. Get more understanding of how it works and associations.

  1. 2. Basic row count of each of the tables before and after filtering.

  1. 3. Count of Customers by Catalog.


Also, I am trying to apply the filters to our data based on logic (see below). Few questions

Here is the rpg statement.

****Several things to exclude....intercompanies, store transfers, plant usage, store bill..    

Note:  SLSNR1=First character of SLSNR field.

 

IF        SLSNR1=7 Intercompany         

Or SLSNR1=8 Nasco West           

Or SLSNR1=9 Arnold Nasco         

Or SLSNR>=11 and SLSNR<=19 Store account Sales  

Or CUSNR=66660100 Nasco Plastics       

Or CUSNR>=99950100 Triarco              

Or CUSNR>=99990100 and CUSNR<=99990199       I/C-Nasco Modesto    

Or CUSNR>=99990200 and CUSNR<=99990299       I/C Nasco

Or CUSNR>=99990500 and CUSNR<=99990599       Store transfer

Or CUSNR>=99990800 Employee Pricing     

Or ITLOC='RETRN' Returns              

eval      VALID=*BLANKS 

  endif                                                                       


8 Replies
swuehl
MVP
MVP

Sorry, I don't know IBM rpg very well, but I already struggled with your initial 3 requirements which are too general for me to answer in a precise way.

Could you detail these three requirements, i.e. what your exact question is related to each one?

Not applicable
Author

To make this more simple I am just trying to COUNT customer number by the catalog so in the app overview it looks like this:

count customer by catalog.png

 

Not applicable
Author

To make this more simple I am just trying to COUNT customer number by the catalog so in the app overview it looks like this:


count customer by catalog.png

jepeerik
Contributor III
Contributor III

Yes, we need more details to give an answer to your questions.

But besides that, I think you can better post your question on the Qlik Sense forum. There you'll get your answer quicker, because more Qlik Sense specialist are present.

https://community.qlik.com/community/qlik-sense

Sharing knowledge increases your knowledge
oknotsen
Master III
Master III

No need to post it there.

I just moved the topic to the Sense section.

Enjoy!

May you live in interesting times!
jepeerik
Contributor III
Contributor III

You'll need a Set Analysis in your Expression.

Try this: COUNT({< CATLG= {A} >} Customer_CUSNR)

Sharing knowledge increases your knowledge
swuehl
MVP
MVP

Try

=Count(If( CATLG = 'A', Customer_CUSNR))

Not applicable
Author

Where has this been moved to exactly? I cant find it.