Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
my first post 🙂
I searched the group but can't find a proper solution for my problem.
I used the auto calendar and try to visualize the YTD value per fiscal year in a bar chart with the option to select a dedicatded month. I tried to realized it with set analysis.
Found this: https://community.qlik.com/t5/QlikView-Documents/QlikView-App-Set-Analysis-Prior-Period-Comparison/t...
whats really good, but didn't worked with auto calendar.
The qvf is attached.
Hi,
for all who are interessted in a possible solution.
I created a fical month mapping table and use these fiscal month in my set analysis.
worked fine for me.
Br
What are you hoping to see as your output?
Hi,
the output should be, that when i select i.e February, that I get the ytd for all years in the data starting from the fiscal year start (01.10.xxxx) till February for all years in the data.
Br,
Try this may be
Sum({< Kategorie = {'Instore'}, [Auftragsdatum.aC.Date] = {"=If(GetSelectedCount([Auftragsdatum.aC.Month]) = 0, [Auftragsdatum.aC.Date], SetDateYear(Only({1}[Auftragsdatum.aC.Date]), Year(Today())) <= SetDateYear(vMaxDate, Year(Today())))"}, [Auftragsdatum.aC.Month] >}[Versand nach Retouren Netto])
Hi sunny,
thanks for the reply.
No, it doesn't worked.
I found the error for the YTD stuff, based on the point, that in the filter pane you have to eliminate the "=" sign.
don't know why, but the behavoir differs if you select from =[field] or field.
But i can't you the expression in the bar chart.
SUM({<Kategorie={'Instore'}, [Auftragsdatum.aC.Fiskaljahr]={'$(vMaxFYear)'},[Auftragsdatum.aC.Date]={"<=$(vMaxDate)"}, [Auftragsdatum.aC.Month]=>}[Versand nach Retouren Netto])
I can compare like month_num <= max(month), but I use fiscal year starting in October.
So the set analysis count the value till january, but I have to count till October the year before....
Hi,
for all who are interessted in a possible solution.
I created a fical month mapping table and use these fiscal month in my set analysis.
worked fine for me.
Br