topic Re: Problem with comparing same dates last year in QlikView

Problem with comparing same dates last year

Tue, 24 Jul 2012 00:01:05 GMT

I need to be able to choose a variety of dates and then show the equivalent dates for previous years (ie minus 364 days).

I want to be able to show a single table with the current years data and a separate table for the previous years data.

Can someone please provide me with a suggestion to do this.

Thanks

Leigh-Anne

Re: Problem with comparing same dates last year

Tue, 24 Jul 2012 08:47:55 GMT

Hi,

If you are using QV11, you can read more on alternate states. If you are using previuos versions, you need to detatch one table to do comparative analysis.

Regards,

Xue Bin

Re: Problem with comparing same dates last year

jvitantonio — Tue, 24 Jul 2012 08:48:49 GMT

=date(DateField-365,'DD/MM/YYYY')

Re: Problem with comparing same dates last year

jonathandienst — Tue, 24 Jul 2012 09:09:56 GMT

Do you want to show the dates for the previous year or the data for those dates? Assuming its the latter:

table1: Dimension: Date

Expression: Sum({<Date = {">=$(=YearStart(Date))"}> Amount)

table2: Dimension: Date

Expression: Sum({<Date = {">=$(=YearStart(Date, -1)) <$(=YearStart(Date))"}>} Amount)

If you create a year field in your load script, then its easier:

Sum({<Year= {"$(=Max(Year))"}> Amount)

Sum({<Year= {"$(=Max(Year)-1)"}> Amount)

Hope that helps

Jonathan