topic Re: Sum a number or flaged items from one point in QlikView

Sum a number or flaged items from one point

Sun, 16 Feb 2014 17:41:23 GMT

Hi guys,

I have a problem and limited time to solve it. Maybe you can help.

I have data with this configuration:

What I want to do is count backwards from the 15/01/2014 date, only the first 5 flagged values. Something like:

=Sum({$<Date= {"<=15/01/2014"},FLAG = {"1"}>} VALUE)

but I need to limit the flag to the first 5 occurrences. Is that possible?

Thank you so much for your help.

Kind regards,

Nuno

swuehl — Sun, 16 Feb 2014 17:46:37 GMT

Maybe something like

=Sum({$<Date= {"=rank(only( {<Date= {"<=15/01/2014"},FLAG = {"1"}>} Date)<=5"} >} VALUE)

Sun, 16 Feb 2014 18:55:27 GMT

Thank you swuehl.

After changing double quotes to single and adding an extra parenthesis, it worked perfectly.

You are truly a legend...