Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
AJ
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.
Would it be possible to attach the qvw with some dummy data and the charts of concern.