Solved: Re: Set analysis Date Range - Page 4 - Qlik Community

tyagishaila · ‎2016-10-09

Dear Community members,

I have these two fields

Created Date	Close Date
1-Oct-16	1-Oct-16
2-Oct-16	2-Oct-16
3-Oct-16
4-Oct-16
5-Oct-16	7-Oct-16
6-Oct-16
7-Oct-16	7-Oct-16
8-Oct-16

And expected result is

	Total	Open	Close
1-Oct-16	1	0	1
2-Oct-16	2	0	2
3-Oct-16	3	1	2
4-Oct-16	4	2	2
5-Oct-16	5	3	2
6-Oct-16	6	4	2
7-Oct-16	7	3	4
8-Oct-16	8	4	4

means for every date , date range start with 1-Oct-16.

Total: suppose we check for 6-Oct-16 than total created date must be the total of 1st to 6th.

Open

sunny_talwar · ‎2016-10-12

Sounds good.... let try to make this possible

tyagishaila · ‎2016-10-12

Good Luck.

I know you will do it.

Ameen.

sunny_talwar · ‎2016-10-13

So, I spent a lot of time thinking about this and I am still trying to figure out what we need to display. For instance, lets take a look at this

Row 1 -24-Sept-16

1-3 days will show order which were created between 22-Sept-16 and 24-Sept-16 are still open?

Row 2 - 1-Oct-16

1-3 days will show order which were created between 29-Sept-16 and 1-Oct-16 are still open?

Row 3 - 8-Oct-16

1-3 days will show order which were created between 6-Oct-16 and 8-Oct-16 are still open?

I know you explained month. So 1-3 day from the last day of the month, right?

and finally daily would be the same as Weekly. So each day would show the order created within last three days and are still open?

Anil_Babu_Samineni · ‎2016-10-13

Sunny, I Appreciate Your Harmful Help to tyagishaila

As i Figure out, This is the Second Thread which is long conversation. Thanks for helping to Employees. i've learned new things here

1) Re: Display message per selection

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

tyagishaila · ‎2016-10-13

Yes you are right. exactly this is my requirement.

And really really very very thanks Sunny to spent a lot of time on this.

Thanks

Shaila

tyagishaila · ‎2016-10-13

Yes Anil you are right.

sunny_talwar · ‎2016-10-21

Did the open expression ever work for you? Or did you use the approach of using column labels

Total-Closed

tyagishaila · ‎2016-10-21

No Open expression did not work. I used Total -Closed for open cases

sunny_talwar · ‎2016-10-21

I think we will have to make the Open expression work for this bucketing to be done. I will keep digging