Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
stabdha91
Contributor III
Contributor III

Monthly data into weekly and daily.

Hi all,

I have a situation where the data is on monthly basis but i want to calculate it on weekly and daily basis.

**Data in attached sheet.

I want to create bar chart for 'Received'/'Resolved'/'Rollover'/'Inventory'

Received :  No. of tickets received monthly/weekly/daily

Resolved : No. of tickets resolved monthly/weekly/daily

Rollover : No. of tickets rolled to next month/week/day

Inventory: No. of tickets carry forwarded to next month/week/day

For Monthly basis i am getting correct data for Received/Resolved/Rollover/Inventory but not for weekly and daily.

11 Replies
stabdha91
Contributor III
Contributor III
Author

Thanks for the solution Nitin but something is wrong there. Number of Received tickets should be equal to number of tickets resolved if there is no carry forward/open tickets in last week.

stabdha91
Contributor III
Contributor III
Author

For this what i did is :

1.) created first_rolling_day

2.) created first_rolling_week

3.) created first_rolling_month

4.) created days_between_rolling

5.) created week_between_rolling

6.) created month_between_rolling

and then in script:

1.) marked all tickets with open_date as OPEN

2.) marked all tickets with close_date as CLOSED

3.) marked tickets as Rolling where first_rolling_day/week/month > base_date(01/05/2016) running an iternation as

iterno() <= month/week/days_between_rolling.