Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to present rolling pipeline in QlikView?

I am trying to work on an application wherein for every month I need to show data for 3 months. eg:

Sales Month = Jan, Show sum of Pipeline for Sign Date between Jan and Mar
Sales Month = Feb, Show sum of Pipeline for Sign Date between Feb and Apr

Sales Month = Mar, Show sum of Pipeline for Sign Date between Mar and May

..... so on and so forth. There is no relation between Sales Month and Sign Date.

The output I am looking for from the attached QV application is attached as an image.

Thank you in advance for your help,

Dipti

3 Replies
giakoum
Partner
Partner

create a link table in your script and use the new field to sum upon :

Sales MonthDimension
201301201301
201302201301
201303201301
201302201302
201303201302
201304201302

etc...

PradeepReddy
Specialist II
Specialist II

Try the bellow expression...

Sum(IF([Sign Month]>= [Sales Month] and [Sign Month] <= [Sales Month]+2, Pipeline))

Thanks,

Pradeep

giakoum
Partner
Partner

Pradeep this is a really really bad solution, if I may say so. Please read QV best practises documents where you can see why.