topic Re: Compare date from previous year with date from current year in QlikView

Compare date from previous year with date from current year

Tue, 28 Oct 2014 10:39:02 GMT

Hi there,

i have still the problem, that i am not able to compare a date from previous year with a date of the current year.

i.e. 15.05.2013 vs. 15.05.2014

I want to show the last 30 days vs the same days in the previous year.

I am using a line chart with these dimensions: Date (=if(Datefield>=date(today()-30), Datefield)

Plattform (there are about 10 plattforms)

Field for formula: amount of article

And now i want to have two lines in the chart: one for the current year and one (as pointed line) for previous year.

I have allready tried this in expressions, but no data will shown:

=AVG({$<FieldYear={$(=Max(FieldYear))}>}[Article Online])

=AVG({$<FieldYear={$(=Max(FieldYear)-1)}>}[Article Online])

Could somebody help me?

Thanks and best regards

Sabrina

something like this; in this example the 2nd line for prev year is missing!

Re: Compare date from previous year with date from current year

Tue, 28 Oct 2014 10:49:01 GMT

Hi,

Try like this

=AVG({$<FieldYear={$('=Max(FieldYear'))}>}[Article Online])

=AVG({$<FieldYear={$('=Max(FieldYear)-1')}>}[Article Online])

Re: Compare date from previous year with date from current year

Tue, 28 Oct 2014 10:53:30 GMT

Doesn't work 😞

No data available... any idea else?

Re: Compare date from previous year with date from current year

Tue, 28 Oct 2014 10:56:56 GMT

Mistake by myself!

This is the result of your changes, but now the plattform is missing (Agenda for years) 😞

Re: Compare date from previous year with date from current year

Tue, 28 Oct 2014 10:59:56 GMT

Hi,

I think in dimension that is Date (=if(Datefield>=date(today()-30), Datefield)

in dimension values it has only this year values below 30 days only so it doesn't show previous year data as a line.bcoz in the dimension we have only values like 1/10/2014,2/10/2014.......29/10/2014

here we don't have 2013 values in dimension so it won't show the line.

Re: Compare date from previous year with date from current year

Tue, 28 Oct 2014 11:03:54 GMT

Hi,

this could be the reason!

I am new in using Set Analysis, how can i conform the expressions that i get the same last 30 days?

Thanks in advance und best regards,

Sabrina

Re: Compare date from previous year with date from current year

Tue, 28 Oct 2014 11:08:16 GMT

Hi,

Try to impliment in some other charts gauge and text objects.it will differenstiate the curr year and prev year [Article Online]

Re: Compare date from previous year with date from current year

Wed, 29 Oct 2014 07:15:10 GMT

Hi Rakesh,

i tried to switch into other diagrams but nothing works fine for me.

I think your idea regarding dimension date is the right way.

I want to implement a set analysis function to the expressions, which give me also the last 30 days.
Could you help me how to build this?

Thanks and regards

Sabrina