topic Re: Straight table question - rolling window view in QlikView

Straight table question - rolling window view

Anonymous — Fri, 31 Aug 2018 13:33:12 GMT

I want to build a straight table as per the attached example.

basically I want to be able to see the employee metrics across a certain # of weeks (rolling window) to be able to assess their performance.

Is it possible to do in Qlikview in an easy and quick way?

Please assist.

Thanks,

Amit

Re: Straight table question - rolling window view

vamsee — Fri, 31 Aug 2018 13:47:20 GMT

Hello,

Are you trying to replicate your excel table in Qlik?

If yes

QlikView Excel Files

Re: Straight table question - rolling window view

Anonymous — Fri, 31 Aug 2018 14:00:04 GMT

No the excel table is an example of the layout I want to see in Qlikview.

I need that historical/rolling view across weeks.

Re: Straight table question - rolling window view

vamsee — Fri, 31 Aug 2018 14:21:40 GMT

Apologies I misinterpreted your questions. Can you please elaborate what you mean by Rolling window?

Are you looking for a Rolling average based on the number of weeks user selects or just view data based on user selection!

Re: Straight table question - rolling window view

Anonymous — Fri, 31 Aug 2018 16:47:49 GMT

That's right. The same metrics, Sales/Hr, UPT and ATV are provided for a 3 weeks period as an example based on the week user selects. Is there an easy way to do that or I need to do a set expression for each week separately?

Re: Straight table question - rolling window view

vamsee — Fri, 31 Aug 2018 18:20:29 GMT

Hi Amit,

Firstly, I would suggest you do a crosstable of your data as your weeks are getting added as columns.

Crosstable with multiple Attribute/Data fields

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/crosstable.htm

The Crosstable Load

------

Post that you can filter your data in UI based on Sales/UPT/ATV.

The second step is to create a calendar based on the week number to enable better UI selections for user.

Generate Master Calendar with dates and join based on WeekNumber.

The Master Calendar

-------

I'm not sure if you meant rolling average or view data. If its rolling average, then have a look at the following documents post above steps.

Set Analysis for Rolling Periods

Calendar with flags making set analysis so very simple