topic Re: previous year's data regardless of current data in QlikView

previous year's data regardless of current data

arsa6978 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

pls take a look at attached qvw.

Do you know a soloution to show previous year's data regardless of current data even by select a Date range?

Result schould be like this:

	FirmaDim	TOTAL	TOTAL	TOTAL	X	X	y	y
Wochentag	Dim	Abweichung	Pakete	Vorjahr	Pakete	Vorjahr	Pakete	Vorjahr
Mo		752%	511	60	326	1,00	185	59,00
Di		202%	793	263	327	203,00	466	60,00
Mi		-58%	231	551	45	204,00	186	347,00
Do				552		300,00		300,00
Fr				553		400,00		400,00
Gesamt		76%	1.535	1.489	698	1108,00	837	1166,00

Thanks!

Re: previous year's data regardless of current data

Anil_Babu_Samineni — Wed, 01 Apr 2020 11:56:39 GMT

If i understand correctly, Create one field in script

Year(Datun) as Year

And, They try expression like

Pick(Match(Dim,'Pakete','Vorjahr','Abweichung'),
Num(sum(AnzahlPakete), '#.##0'),
Num(sum({1<Year={"$(=Max({<Datun, Range>} Year-1))"},WeeksAgo = {$(vWeeksAgo)}>} AnzahlPakete),'#.##0'),
Num((sum( AnzahlPakete) /
sum({1<WeeksAgo = {$(vWeeksAgo)}, Key = {"=Sum( AnzahlPakete)>0"} >} AnzahlPakete))-1,'#,%'))

Re: previous year's data regardless of current data

arsa6978 — Wed, 01 Apr 2020 13:04:42 GMT

Thanks for your reply, but it doesnt work. For more clearness i added second table (Bestand2).

I want to show in Total only the difference in percent. Taht's why i have FirmaDim and Dim as Dimensions.

At the same time i want to show the previous year value in selected Range. Unfortunately, it is only displayed if there is data for this year ...

Re: previous year's data regardless of current data

arsa6978 — Wed, 08 Apr 2020 07:43:01 GMT

Any Idea, suggestions ...?

Re: previous year's data regardless of current data

Brett_Bleess — Wed, 22 Apr 2020 21:13:28 GMT

Have a look at the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

There are some related links on that one at the bottom to further/related posts as well.

Regards,
Brett