Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rdsuperlike
Contributor

what if slider with data shift

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

Tags (3)
4 Replies
sicilianif
Contributor

Re: what if slider with data shift

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
Contributor

Re: what if slider with data shift

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
Contributor

Re: what if slider with data shift

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

rdsuperlike
Contributor

Re: what if slider with data shift

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