Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I,m using QlikView 11.2 SR12 and have an unexpected behavior, with if, above and set analysis in a straight table.
The dimension for the straight table is cal_Month
My expression is the following
if(Dimension='dimension',num(Above(sum({$<date=,cal_Year={'$(=Year(vEndDate))'}>} Value),1)/above(sum({$<date=,cal_Year={'$(=Year(vEndDate))'}>} Value),2),'#.##0,0'), num(sum({$<date=,cal_Year={'$(=Year(vEndDate))'}>} Value),'#.##0') )
The num(sum({$<date=,cal_Year={'$(=Year(vEndDate))'}>} Value),'#.##0') part is shown correctly for every month, the problem is the
num(Above(sum({$<date=,cal_Year={'$(=Year(vEndDate))'}>} Value),1)/above(sum({$<date=,cal_Year={'$(=Year(vEndDate))'}>} Value),2),'#.##0,0') Part
it seem, that the set analysis is ignored so i got the correct value only for the selected date period. Has someone any idea how to fix that?