Thanks for your reply...
POCPODueDate and POCSOShipDate are coming from the same table (i've joined several table from an ODBC database for this report) - see attached...
What do you mean by create flag in the script? There were cases in other reports where I had to do mathematical calculations in the script to create new fields that I would use in the front end, but I have never used an expression with a logical outcome... which is what I think you are referring to...
Can you give me an example so I can understand?
POC Table.JPG 50.9 K
this is a great feature which I didn't know existed..
Only been using qlikview for about 6 months or so...
it took a bit of experimenting and I ended up setting it up a 2 dimension multibox, for some reason the when selecting N/C I was getting some of the others as well, which I havent really understood why yet...
what I ended up using is:
1: Setup an expression in a multibox filters out all the N/C: (not committed)
=IF(POCPOLineQtyCommit > 0,'Committed QTY Exists', 'No Committed QTY')
- Where there is no Committed QTY, POCPOLineQTYCommit will be NULL "-"...
Then for all entries where there is a value in POCPOLineQtyCommit, I setup a Flag in the script connecting to the Master Table via POCPOrder field as per below:
IF(POCPODueDate>(POCSOShipDate-10),'Late'))as POCDueDateStatus Resident POCMaster;
Then I used POCDueDateStatus in my multibox as the second selection...
I have tried a few ways to combine these two selections in the script, but haven't been able to as yet,
I have tried:
IF(POCPODueDate>(POCSOShipDate-10),'Late')))as POCDueDateStatus Resident POCMaster;
Can you think of anything I could try to combine these 2 expressions in the script?