topic Weekly trends chart in QlikView

Weekly trends chart

Fri, 17 Oct 2014 18:57:22 GMT

Hello,

I have a line chart with year-week and sales_area as dimensions and net sales as expression. For net sales I have to sum 3 separate fields in the table say sale_1, sale_2 and sale_3.

So my expression is something like

AGGR((SUM(sales_1) + SUM(sales_2) + SUM(sale_3)),sales_area,year-week)

Not all sales_area may have made a sale in any particular week.

How do I get the chart for say last 4 or 5 weeks only? I tried using dimension limits for year-week (largest, smallest, first) but I am not getting correct results as sometimes the weeks are not continuous, sometimes some sales areas are not displayed etc.

thanks for helping.

Manoj

Re: Weekly trends chart

Fri, 17 Oct 2014 19:08:52 GMT

Hi,

You could modify your chart some thing like :

if(week(today())-Week(field)>4,exp)

If possible upload sample.

Kiru

Re: Weekly trends chart

maxgro — Fri, 17 Oct 2014 19:45:54 GMT

PFA

Re: Weekly trends chart

Fri, 17 Oct 2014 20:01:15 GMT

Hi,

Please have a look at the attached file and hopes it help!

Kiru

Re: Weekly trends chart

Fri, 17 Oct 2014 22:25:10 GMT

Hi Massimo,

Somehow SUM({$....} sales1 + sales2) doesn't work for me but SUM({$...} sales1) + SUM({$...} sales2) does.

I noticed the same thing in my another dataset as well.

thanks,

Manoj