topic Re: regarding set analysis exp? in QlikView

regarding set analysis exp?

d_koti24 — Mon, 29 Jun 2015 08:05:04 GMT

Hi All,

I want display the data weekly wise and monthly wise in chart.How to achive this?

weekly -today() to last monday

monthly-29/06/2015 to 29/05/2015

regards,

Re: regarding set analysis exp?

buzzy996 — Mon, 29 Jun 2015 08:47:39 GMT

u can try this way,u can create drill-down group with ur week and Month data fields,by changes the those/selecting (either week or month) on chart u can get corresponding information in ur chart.

Re: regarding set analysis exp?

Mon, 29 Jun 2015 08:58:57 GMT

Hi,

You need to use like below,

As per your requirement,

=sum({<CalDate = {">=$(=Date(max(CalDate)-31))<=$(=max(CalDate)) "},CalQuarter=,CalMonth=,CalYear=>}Sales)

Another approach,

=sum({<CalDate = {">=$(=Date(Monthstart(max(CalDate))))<=$(=max(CalDate)) "},CalQuarter=,CalMonth=,CalYear=>}Sales)

=Sum({<CalMonthYear={"$(=Monthname((Max(CalDate))))"}>} Sales)

=Sum({<CalWeek={"$(=week((Max(CalDate))))"}>} Sales)