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
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?
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.