topic Time Comparison in QlikView

Time Comparison

Tue, 23 Feb 2016 08:43:27 GMT

Hi All,

My data contain year, month, day and income.

I need to compare Day income to the same day last year, month, quarter....

I have MulteBox for Year, Month and Day selection. When i selectYear, Month, Day i can compare only with the days in the selection month.

For example: if i select 22/02/2016 i can compare only to the last 21 days and i want 356

Thanks for your help

sunny_talwar — Tue, 23 Feb 2016 17:32:23 GMT

You can explore using Above() function or using AsOf Table -> The As-Of Table

swuehl — Tue, 23 Feb 2016 17:37:41 GMT

You can also look into using set analysis for point in time reporting:

Not sure why you are only able to compare to days in the same month, could you explain your issue a bit more detailed?