Want to show past four months and coming eight months data in Trend combo chart

[Vinni2000]

I have date field " Expiration Date"

I want to show the Expiring Tickets counts and its Value in a Combo Chart for past four months and coming eight months

Fields :

Ticket ID

Value

Expiration Date

[jcmachado]

To show the past four months and coming eight months data in a trend combo chart in QlikView, you can use the following steps:

1. Create a new Combo Chart object and set the dimension as "Expiration Date" and the two expressions as "Count(Ticket ID)" and "Sum(Value)".

2. In the chart properties, go to the "Axis" tab and set the "Min" and "Max" values for the x-axis to show the past four months and coming eight months data. You can use the date functions like MonthStart() and AddMonths() to set the x-axis values.

3. Example: Min: MonthStart(AddMonths(Today(),-8)) Max: MonthStart(AddMonths(Today(),4))

4. Go to the "Presentation" tab and set the "Number of data points" to 12 so that the chart shows 12 data points for past four months and coming eight months data.

5. Finally, on the "Data" tab, enable the "Group by" option and set the "Group by" field as "Expiration Date". This will group the data by month, so the chart will show the data for each month separately.

6. Now the chart will show the Expiring Tickets counts and its Value for past four months and coming eight months.