Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
in the attached qlikview i have 3 graph objects, 2 out of 3 are independant of whatever month is selected, it always shows the total current year.
i also want this in the the table "top sales YTD", but there it doesn't work and i don't understand why...
i use "1" in the set analysis to make it independant of current selections but in that table it does not seem to work.
can someone help me with the reason why?
thanx!
grtz,
chris
It doesn't change at my side...
(You need to use only({1} ...) around the aggr() function also for the sort expression to avoid some re-sorting).
Try
if(only({1}Aggr(Rank(Sum({1<Shop={'Pomax Store Wijnegem'},Year={$(= Max(Year))}>}LineSalesAmount)),ProductGroupLevel1,SkuCode))<=3,Sum({1<Shop={'Pomax Store Wijnegem'},Year={$(= Max(Year))}>}LineSalesAmount))
Hello,
it still changes if i select different months...
chris
Hi
PFA
Hope it helps
It doesn't change at my side...
(You need to use only({1} ...) around the aggr() function also for the sort expression to avoid some re-sorting).
ok, i forgot to do it in the sorting, and that was probably why i saw things changing...
thanx!
chris