Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
vignesh_s
Creator
Creator

hi

I was learning about 'Above' Function ,i worked out with some example but i geting the wrong result,the -ve value is not printing ,can any1 help me to solve ths...

1 Solution

Accepted Solutions
sunny_talwar

You have two dimensions? May be you need Above(TOTAL Units)... but not entirely sure what the goal is...

View solution in original post

4 Replies
sunny_talwar

You have two dimensions? May be you need Above(TOTAL Units)... but not entirely sure what the goal is...

View solution in original post

vignesh_s
Creator
Creator
Author

Thanks its working ,but i have doute tat why we are using total of unit,can u expalin it

sunny_talwar

Above() function, without TOTAL, only looks at the above field when your second last dimension is the same... so when you had ProductID and Units as dimension... you only saw a value for Above() when ProductID repeated (ProductID = 3)... Whereas Above(TOTAL) looks above regardless of changing dimensions. If you want to use Above(), you probably need to use just ProductID with Sum(Units) intead of just units

vignesh_s
Creator
Creator
Author

Thank You,it helped me alot