Discussion Board for collaboration related to QlikView App Development.
Hello,
in my script I had following codeline:
if(duedate<=Today() and [Status (Allg)] <> 'done' and [Status (Allg)] <> 'deleted'and [Status (Allg)] <> 'broke' and (Zuordnung = 'supply chain'or [Zuordnung] = 'SP'),1,0) as [main.OverdueFlagDZ], |
---|
So when I load my data from my database I get a flag for an task that is not done yet but its date is beyond the duedate.
My problem now is that I use increment load to only add the new data and the old one is loaded from the stored qvd, so its not working the way I want it anymore.
I declared an variable so that it counts my tasks, but I get some error expressions:
=Count({<main.Zuordnung={'Supply Chain','SP'}, [Main.duedate]<=Today(), [main.Status (Allg)]={'open','active'}>}main.Kategorie |
---|
Sorry, sometimes the syntax really confuses me.
Try this one:
=Count({<main.Zuordnung={'Supply Chain','SP'}, [Main.duedate]={'<=$(=Today())'}, [main.Status (Allg)]={'open','active'}>}main.Kategorie)
Try this one:
=Count({<main.Zuordnung={'Supply Chain','SP'}, [Main.duedate]={'<=$(=Today())'}, [main.Status (Allg)]={'open','active'}>}main.Kategorie)