Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Sorry unable to understand your requirement.
Kindly explain what out put you are looking for,
Regards,
Kaushik Solanki
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
Any ideas?
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.
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