Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to achieve 3 items based on filtering:
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
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?
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:
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:
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
No need to post it there.
I just moved the topic to the Sense section.
Enjoy!
You'll need a Set Analysis in your Expression.
Try this: COUNT({< CATLG= {A} >} Customer_CUSNR)
Try
=Count(If( CATLG = 'A', Customer_CUSNR))
Where has this been moved to exactly? I cant find it.