Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unexpected Behaviour with if, above,below and set analysis

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?

0 Replies