topic Re: Date flag needed in QlikView

Date flag needed

Mon, 03 Nov 2014 07:53:28 GMT

I have the following table:

As you might notice some of the values in table A is in red represents a problem.

It has 2 dimensions (Staff & Date) with an expression sum(hours).

What i want to achieve is the following (end result is B). All dates prior to the oldest "problem date" needs to hidden. i dont want to hide all "non problem" dates, only the one's prior to the oldest "problem date".

Any help here? the minimum value of the problem fields is specified in a seperate table per day (in other words 16,17,18,19,20,21,22,23 october = 8. in this example i need some calculation that will give me the answer 19 October (which i can then use in a IF statement in dimensions)

Re: Date flag needed

vinay_hg — Mon, 03 Nov 2014 08:39:46 GMT

in the script level use a variable to store last problem date, compare that date in date field used in dimesion if u r using if condition or use setanalysis in expression.

Re: Date flag needed

Mon, 03 Nov 2014 08:45:56 GMT

That is my problem i cant get the calculation correct.

i need to go look at a specific date, look at the hours for each staff member and if anyone of them is less than 8 raise the flag.