topic Issue with 2 date ranges in QlikView

Issue with 2 date ranges

Anonymous — Mon, 13 Jan 2014 20:18:50 GMT

Hello all,

I'm having an issue with 2 date ranges.

I'm trying to have a chart that shows hire dates within a range and another chart that shows terminations in a different range.

Whenever I select a date range from both charts, the data gets filtered into showing employees who were hired and terminated in the date range instead of showing who was hired in that range on one chart, and who was terminated in that range in another chart.

The dates come from the same table.

Any help is greatly appreciated on this.

Re: Issue with 2 date ranges

Mon, 13 Jan 2014 20:28:23 GMT

Hi,

You can achieve this by using Set Analysis.

When looking at table with Hired data put 'Terminated date=' in set analysis and similarly when looking at table with Terminated data put 'Hired date=' in the expression along with the other necessary parameters. I did something similar to this.

Hope it helps.

Thanks

Re: Issue with 2 date ranges

Anonymous — Mon, 13 Jan 2014 21:22:13 GMT

Thanks for the reply AJ.

This works when I select one date range and not the other, however, when I have both ranges selected at the same time, neither chart calculates.

Re: Issue with 2 date ranges

Mon, 13 Jan 2014 22:21:41 GMT

Would it be possible to attach the qvw with some dummy data and the charts of concern.