topic Re: Re: Slide with Last Hours? in QlikView

Slide with Last Hours?

Tue, 09 Sep 2014 10:24:30 GMT

Hi guys, ive got a tricky one that has made me scratch my head for a while now.

I need to sum certain dimension, so lets call it Sales for demonstration reasons, but the user needs to have a slide, the slide consists of numbers from 1 to 24, which represent hours.

So if the user moves the slide to 10 it will show me sum(Sales) for the last 10 hours.

This will ideailly need to work when its 2AM and I need the last 10 hours, it would show me the sum(sales) since 4PM the previous day.

And so on as the user moves the slide around

Many Thanks

Re: Slide with Last Hours?

MK_QSL — Tue, 09 Sep 2014 10:35:51 GMT

Nice one.... Could you please provide some sample/dummy data to work... Would like to work on this...

Re: Re: Slide with Last Hours?

Tue, 09 Sep 2014 10:57:15 GMT

There you have a CSV file, theres 4 colums, TimeTaken, ChangeDat, Ticket and Operator,

I would like to show the TimeTaken and the number of distinct tickets for each operator, within the SLider TimeFrame.

Thanks

Re: Slide with Last Hours?

Tue, 09 Sep 2014 12:48:06 GMT

This is the formula without slider

=sum({<ChangeDat = {'>=$(=timestamp(time(now()-'12:00')))'} >} TimeTaken)

So for the Slider, just create a Inline Table, and call the Inline Table by replacing it with the 12 and leaving the ':00'

Thanks