topic Re: Showing curret years data for previous year for same date in QlikView

Showing curret years data for previous year for same date

deepakqlikview_123 — Mon, 27 Apr 2015 07:00:57 GMT

Hi All,

My date is DD-MM-YYYY format, as per requirement i want to show current years data for same date for previous year.

Please suggest.

Attached is sample application for the same.

Thanks

senpradip007 — Mon, 27 Apr 2015 07:10:42 GMT

If the date is 27-04-2015 then try like

Sum({<YEAR, MONTH, DATE={">=$(=Date(AddYears(Max(DATE), -1),'DD-MM-YYYY')) <=$(=Date(Max(DATE),'DD-MM-YYYY'))"}>} [YOUR FIELD])

deepakqlikview_123 — Mon, 27 Apr 2015 07:28:57 GMT

Hi Pradip,

This is not working.

Thanks

Mon, 27 Apr 2015 07:48:31 GMT

Try This,

=sum({$<Date = {"$(=AddYears(max(Date),-1))"},Month=>}Amount)

ankitaag — Mon, 27 Apr 2015 08:09:46 GMT

Hi Deepak,

Can you please explain what you exactly want? What should be in your dimension?

ankitaag — Mon, 27 Apr 2015 08:11:18 GMT

Hi Elakkian,

Please note that in your expression you are comparig an Year with a Date..which is wrong

Year(Max(Date))-1 will give you Year and not Date

ankitaag — Mon, 27 Apr 2015 08:12:47 GMT

Hi Deepak,

You can store

=Date(AddYears('25-04-2014',-1))

in a variable and then use it,

but again I would like to know what exactly data you are looking for.

Give some sample data and your descriptive requirements.