Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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,'#,%'))
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 ...
Any Idea, suggestions ...?
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