Wrong count?

Wed, 04 Feb 2015 13:47:30 GMT

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.

Re: Wrong count?

Gysbert_Wassenaar — Wed, 04 Feb 2015 13:51:30 GMT

Try this one:

=Count({<main.Zuordnung={'Supply Chain','SP'}, [Main.duedate]={'<=$(=Today())'}, [main.Status (Allg)]={'open','active'}>}main.Kategorie)

topic Wrong count? in QlikView

Wrong count?

Re: Wrong count?