Discussion Board for collaboration related to QlikView App Development.
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 MarSales 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,
create a link table in your script and use the new field to sum upon :
Try the bellow expression...
Sum(IF([Sign Month]>= [Sales Month] and [Sign Month] <= [Sales Month]+2, Pipeline))
Pradeep this is a really really bad solution, if I may say so. Please read QV best practises documents where you can see why.