Set Analysis From-To Dates

[eleni_theodorid]

Hi team!

I'm trying to do the following:

In a straight table I have two dimensions,branch and date and one expression,Data.

I want a new expression to count dates,only in rows that the Data is null,between the current row and the first row that Data is not null.

[kaushiknsolanki]

Hi,

     Sorry unable to understand your requirement.

     Kindly explain what out put you are looking for,

Regards,

Kaushik Solanki

[eleni_theodorid]

Hi,

I attach a second qvw in column Results you could find the result we expect and at the text object the way we have to calculate it. I kow that it's a little bit confused please let me know if you need further information.

Thanks in advance,

Eleni

[eleni_theodorid]

Any ideas?

[Gysbert_Wassenaar]

As far as I know you won't be able to do this with an expression. You'll need to fix this in the script. See attached qvw.

[eleni_theodorid]

Dear Gysbert,

I really want to thank you for your answer, but we are looking for a layout solution. We are trying to find out if there is any Set Analysis or something to do that at the front end.

Thank you very much,

Eleni