topic Back log for Open cases in QlikView

Back log for Open cases

Tue, 16 Sep 2014 06:41:44 GMT

I have a requirement where if user selects year then he need to see the data for max week of that year and if he selects quarter he should see max week data of that quarter and if he selects month then he need to see max week of that month and if he selects week he need to see particular week data.

Year data is 2014

quarter data is 2014-Q1,2014-Q2 and

month data will be 2014-01,2014-02... and

week data will be 2014-W01,2014-W02 ...2014-W52.

for ex: in 2014 my last load date is 16/09/2014 then if he selects year he needs to see this load data as of 16/09/2014.

if he selects 2014-Q1 then he needs to see data for last week of march load date data.

if he selects month 2014-05 then he needs to see data for last week for that month.

could you please help me on this

Re: Back log for Open cases

marcus_sommer — Tue, 16 Sep 2014 06:57:27 GMT

You could use a searchstring to select the week or an expression which ignored all further weeks:

search-string: week = week(max(date))

expression: sum({< week = {"$(=week(max(date)))"}>} ANYFIELD)

- Marcus

Re: Back log for Open cases

Tue, 16 Sep 2014 07:27:47 GMT

Hi,

Check the attached application solution and do modifications accordingly in your script or code.

Regards,

Ravikumar