Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eleni_theodorid
Partner - Creator
Partner - Creator

Set Analysis From-To Dates

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.

5 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Sorry unable to understand your requirement.

     Kindly explain what out put you are looking for,

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
eleni_theodorid
Partner - Creator
Partner - Creator
Author

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
Partner - Creator
Partner - Creator
Author

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.


talk is cheap, supply exceeds demand
eleni_theodorid
Partner - Creator
Partner - Creator
Author

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