topic Re: Set Analysis Issue in QlikView

Set Analysis Issue

vipin_mishra479 — Wed, 02 Jul 2014 10:14:26 GMT

Hi All,

i have week wise data like this

and my current week is 3

and want to show this in my chart

week Sales

1 past week and 1 future week of my current week.

ashfaq_haseeb — Wed, 02 Jul 2014 10:31:13 GMT

Hi,

Take week as your dimension.

write below expression.

=sum({<Week={'>=$(=week(today())-1)<=$(=week(today())+1)'}>} Sales)

Regards

ASHFAQ

sasikanth — Wed, 02 Jul 2014 10:44:14 GMT

try some thing like this

=sum({<week-field>={'>=$(=Week(Month(today()))-1)<=$(=Week(Month(today()))+1)'}>}sales)

Wed, 02 Jul 2014 11:10:36 GMT

Considering it is always for 1 month!

Create a variable v1 (To get current week no of the month):

=Ceil(day(Today())/7)

In chart Dim: Week

Exp :

sum({<Week={$(v1),$(=$(v1)+1),$(=$(v1)-1)}>}Sales)

Regards,

Prabhu