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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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