topic Re: hi in QlikView https://community.qlik.com/t5/QlikView/hi/m-p/1392745#M798994 <HTML><HEAD></HEAD><BODY><P>You have two dimensions? May be you need Above(TOTAL Units)... but not entirely sure what the goal is...</P></BODY></HTML> Wed, 29 Nov 2017 07:41:30 GMT sunny_talwar 2017-11-29T07:41:30Z hi https://community.qlik.com/t5/QlikView/hi/m-p/1392744#M798993 <HTML><HEAD></HEAD><BODY><P>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... </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/hi/m-p/1392744#M798993 vignesh_s 2020-11-25T16:16:04Z Re: hi https://community.qlik.com/t5/QlikView/hi/m-p/1392745#M798994 <HTML><HEAD></HEAD><BODY><P>You have two dimensions? May be you need Above(TOTAL Units)... but not entirely sure what the goal is...</P></BODY></HTML> Wed, 29 Nov 2017 07:41:30 GMT https://community.qlik.com/t5/QlikView/hi/m-p/1392745#M798994 sunny_talwar 2017-11-29T07:41:30Z Re: hi https://community.qlik.com/t5/QlikView/hi/m-p/1392746#M798995 <HTML><HEAD></HEAD><BODY><P>Thanks its working ,but i have doute tat why we are using total of unit,can u expalin it</P></BODY></HTML> Wed, 29 Nov 2017 07:47:45 GMT https://community.qlik.com/t5/QlikView/hi/m-p/1392746#M798995 vignesh_s 2017-11-29T07:47:45Z Re: hi https://community.qlik.com/t5/QlikView/hi/m-p/1392747#M798996 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Wed, 29 Nov 2017 07:54:24 GMT https://community.qlik.com/t5/QlikView/hi/m-p/1392747#M798996 sunny_talwar 2017-11-29T07:54:24Z Re: hi https://community.qlik.com/t5/QlikView/hi/m-p/1392748#M798997 <HTML><HEAD></HEAD><BODY><P>Thank You<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />,it helped me alot</P></BODY></HTML> Wed, 29 Nov 2017 08:14:42 GMT https://community.qlik.com/t5/QlikView/hi/m-p/1392748#M798997 vignesh_s 2017-11-29T08:14:42Z