topic Re: Help needed: calculate Output (real and planned) in QlikView

Help needed: calculate Output (real and planned)

Wed, 23 Aug 2017 16:26:18 GMT

Hey everybody,

I need to calculate the planned and the real Output of Product in a certain Time Period. My Data Set is as follows:

RealDate	PlannedDate	ProductID
03.11.2016	08.10.2016	125-635
02.01.2016	08.02.2016	126-236
20.10.2016	-	128-236
-	05.06.2017	158-360

The problem is that I need to count both dates for the same time period which I want to determine by a Listbox. This Period could contain several months in several years...I solved it for the situation that I choose only one month in one year, but i want need to choose flexibel time periods for my reports...

I tried the whole day to solve this, but didn´t find a solution. Please help me...

Re: Help needed: calculate Output (real and planned)

Anil_Babu_Samineni — Wed, 23 Aug 2017 16:51:58 GMT

What is the result set you are expecting from providing data

Re: Help needed: calculate Output (real and planned)

Wed, 23 Aug 2017 19:52:24 GMT

Thanks for your answer! I expect for any selection of a time period the Number of PlannedDates and the number of RealDates, which are included in the selected period.

I tried this:

=count( if(PlannedDate>weekstart(Min(Date)) AND DatumPlanEnde<weekend(Max(Date)), ProductID)

Re: Help needed: calculate Output (real and planned)

Wed, 23 Aug 2017 19:54:29 GMT

Sry there was some of the German Code left:

I tried this:

OutputPlanned=count( if(PlannedDate>weekstart(Min(Date)) AND PlannedDate<weekend(Max(Date)), ProductID)

with Date beeing the selected Time Period

Re: Help needed: calculate Output (real and planned)

swuehl — Wed, 23 Aug 2017 20:42:12 GMT

A canonical date may solve your requirement:

Canonical Date