topic Re: Expression to show 7 days forward - forecasting in QlikView

Expression to show 7 days forward - forecasting

Thu, 12 May 2016 12:54:38 GMT

Howdy. Trying to display the rolling 7 days (future) of data to show up and coming work to be realized. How would I write and expression to dynamically show future 7 days based off my established 'Target Date of Completion'

=Count ({<Status={'New', 'In Progress'}, [Target Completion Date]={"<=$(=DATE(MAX(DATE)))>=$(=DATE(MAX(DATE)+7))"} , Account -={'Sage Atlanta CBC'}, Type = {'Trial', 'Pre-production'}, [Account Sales Office] = {'Atlanta CBC'}>}[Success Plan: ID])

Re: Expression to show 7 days forward - forecasting

sunny_talwar — Thu, 12 May 2016 15:52:33 GMT

The date set analysis looks good to me, it isn't working?

Re: Expression to show 7 days forward - forecasting

Fri, 13 May 2016 13:17:03 GMT

Hi Sunny, it’s not working. No matter what I set the days to (e.g. +10, +20, etc…) I’m getting zero as a return when I have upcoming work to realize.

Re: Expression to show 7 days forward - forecasting

sunny_talwar — Fri, 13 May 2016 13:33:31 GMT

Would you be able to share a sample to look at?

Re: Expression to show 7 days forward - forecasting

Fri, 13 May 2016 14:55:48 GMT

On the 'Copy of Copy of Activity' tab.

The number should be 4.. Over the next 7 days, I have 4 accounts converting based on the 'Target Completion Date'

Re: Expression to show 7 days forward - forecasting

sunny_talwar — Fri, 13 May 2016 18:32:58 GMT

Can you check this expression:

=Count ({<Status={'New', 'In Progress'}, [Target Completion Date]={"$(='>=' & Date(Today()) & '<=' & Date(Today()+7))"} ,Account -={'Sage Atlanta CBC'}, Type = {'Trial', 'Pre-production'}, [Account Sales Office] = {'Atlanta CBC'}>}[Success Plan: ID])

Re: Expression to show 7 days forward - forecasting

Fri, 13 May 2016 18:51:32 GMT

very strange...I copied your code, and still get 0 returned results. . Still troubleshooting

Re: Expression to show 7 days forward - forecasting

sunny_talwar — Fri, 13 May 2016 19:07:40 GMT

Did you open the QVW and check if you see the right number?

Re: Expression to show 7 days forward - forecasting

Anonymous — Tue, 20 Dec 2016 07:47:51 GMT

i have emp_id, date, HOURS field! but i want to show hours of per empid in per date! how to do? if i group by the emp_id means it will show the all the data, but i want to single date?

Re: Expression to show 7 days forward - forecasting

Heena — Wed, 06 Feb 2019 13:22:48 GMT

Hi ,

I have data as below.

RN_EXECUTION_DATE	count(RN_RUN_ID)
2018-06-30	18
2018-07-01	24
2018-07-02	55
2018-07-03	101
2018-07-04	79
2018-07-05	93
2018-07-06	83
2018-07-07	2
2018-07-08	4
2018-07-09	5
2018-07-10	20
2018-07-11	8
2018-07-12	11
2018-07-13	15
2018-07-15	176

I need to forecast for next 5 days - count(RN_RUN_ID), i have added days though in the script.

Date(RN_EXECUTION_DATE + 5) as RN_EXECUTION_DATE_Forecast.

but its not working.

measure: count(RN_RUN_ID).

Thanks in Advance!