topic Re: Set Analysis From-To Dates in QlikView

Set Analysis From-To Dates

eleni_theodorid — Fri, 19 Apr 2013 14:36:34 GMT

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.

Re: Set Analysis From-To Dates

kaushiknsolanki — Sat, 20 Apr 2013 17:35:18 GMT

Hi,

Sorry unable to understand your requirement.

Kindly explain what out put you are looking for,

Regards,

Kaushik Solanki

Re: Set Analysis From-To Dates

eleni_theodorid — Tue, 23 Apr 2013 12:15:24 GMT

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

Re: Set Analysis From-To Dates

eleni_theodorid — Wed, 01 May 2013 10:29:17 GMT

Any ideas?

Re: Set Analysis From-To Dates

Gysbert_Wassenaar — Wed, 01 May 2013 10:56:59 GMT

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.

Re: Set Analysis From-To Dates

eleni_theodorid — Wed, 01 May 2013 11:32:14 GMT

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