Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: New to Qlik Sense, Need help with filtering function

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

Re: New to Qlik Sense, Need help with filtering function

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

Re: New to Qlik Sense, Need help with filtering function

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
New Contributor III

Re: New to Qlik Sense, Need help with filtering function

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

oknotsen
Honored Contributor III

Re: New to Qlik Sense, Need help with filtering function

No need to post it there.

I just moved the topic to the Sense section.

Enjoy!

May you live in interesting times!
jepeerik
New Contributor III

Re: New to Qlik Sense, Need help with filtering function

You'll need a Set Analysis in your Expression.

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

MVP
MVP

Re: New to Qlik Sense, Need help with filtering function

Try

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

Not applicable

Re: New to Qlik Sense, Need help with filtering function

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