topic Re: Total count by Start and End dates in QlikView

Total count by Start and End dates

shree909 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks ,

I have a scenario, where i have a data set with start, End, Status and ID.

Start date acts a Filter with year, Month, Quarter.

when i make any selections on the filters i want to capture the monthend and and look for that end date between the start and end date from the duplicate table and show the count on the chart.

for that i created a duplicate table so that i can get all the count,

Example 1:

when 2016 is selected, i want to take the max monthend start date and use that date to check the duplicate table , and see if the dates is between start and end dates and get the count

Example 2:

when 2016 and 2017 are selected, i want to selected the max month end date of 2016 i.e 12/31/2016 and check between the duplicate table and get the count,similarly i want to selected the 2017 12/31/2016 and check the dates between the duplicate table and get the count. both these counts should be shown as a line chart . since these charts are not associated i am seeing only the toal counton 2 years

Please find the sample.

Thanks

Re: Total count by Start and End dates

sunny_talwar — Tue, 07 Aug 2018 19:27:20 GMT

Where do you have to take the count Sree? In the bar chart or text box object? What is the expected output in the above 2 scenarios?

Re: Total count by Start and End dates

shree909 — Tue, 07 Aug 2018 19:32:02 GMT

i want to show those numbers as a line chart on the combo chart.i am attaching the file

Re: Total count by Start and End dates

aarkay29 — Tue, 07 Aug 2018 19:36:36 GMT

Rangesum(Above(Count({<Status={'NEW'}>} ID),0,rowno())) as Line Expresion

Re: Total count by Start and End dates

shree909 — Tue, 07 Aug 2018 19:47:17 GMT

Thanks for the response,

but when ever i select any month ,i need to see the monthend value falls between the start and enddate of the duplicate table. when i use the above formula and make selections it should get the count from the duplicate table.

Re: Total count by Start and End dates

shree909 — Wed, 08 Aug 2018 18:10:18 GMT

Any Help on the above scenario?