topic Re: what if slider with data shift in QlikView

what if slider with data shift

rdsuperlike — Thu, 30 Apr 2015 18:15:52 GMT

I want to get the below data to shift to +- (1 to 5 )days through a wat if slider

Date total

1/1/15 100

1/2/15 35

1/3/15 45

1/4/15 36

1/5/15 67

1/6/15 37

1/7/15 58

If i move by +1 days

OUTPUT should be

Date total

1/1/15 -

1/2/15 100

1/3/15 35

1/4/15 45

1/5/15 36

1/6/15 67

1/7/15 37

1/8/15 58

Any approach is appreciated?

I used above. But couldnt get the corner cases.

eg: 1/8/15 58

sicilianif — Thu, 30 Apr 2015 18:45:14 GMT

I would think that it would be something like this:

set up vDays variable linked to slider.

Change dimension in chart to be a calculation: Date([Date Field]+vDays)

rdsuperlike — Thu, 30 Apr 2015 19:00:56 GMT

I attached my qvw to the main question.

I tried incorporating ur idea..but it doesnt work. It shifts the whole set by 1 day and the corner case is still lost.

sicilianif — Thu, 30 Apr 2015 19:10:16 GMT

Not sure what you mean by lost. In your example, the 2nd chart's data looks fine (all dates are shifted by slider).

rdsuperlike — Thu, 30 Apr 2015 20:29:56 GMT

I want 58 to come up adjacent to 1/9. But instead 38 comes bcz now the new set starts from 1/2 to 1/9 instead of 1/1 to 1/8. see 2nd staright table