Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Comparing create and expiry dates


I have 2 date fields one create date and expiry date....

I want to compare these two dates in the chart side by side with their counts for every year.

can any one please help me in doing this.

3 Replies

Re: Comparing create and expiry dates

Could you provide an example of comparison? What Do you want to know, number of days, of months or what else?

Re: Comparing create and expiry dates

Here is an example, hope it helps but I wait other informations.

Not applicable

Re: Comparing create and expiry dates

When you have two dates, one for creation and other for expiration, usually it is a good idea to use a Triangulation Report. This consists on using a Pivot Chart, and putting one date on columns and the other on rows, and your measure (number of contracts, for example) as your expression for the cells value.

Bellow you have an example of this type of report:



Community Browser