Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
To show the past four months and coming eight months data in a trend combo chart in QlikView, you can use the following steps:
Create a new Combo Chart object and set the dimension as "Expiration Date" and the two expressions as "Count(Ticket ID)" and "Sum(Value)".
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.
Example: Min: MonthStart(AddMonths(Today(),-8)) Max: MonthStart(AddMonths(Today(),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.
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.
Now the chart will show the Expiring Tickets counts and its Value for past four months and coming eight months.