Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a pivot chart in which i have five calculated expressions.
I need to find the maximum of Net Long Positions and Net Short Positions.
I have used the formula,
Max([Net Long Position],[Net Short Position]), but it shows a null value.
Can someone please help and let me know how to get the maximum of the two expressions.
Go to Solution.
Is this a column you're adding to the chart?
rangemax([Net Long Position],[Net Short Position])
Can u attach ur application here?
Maybe instead of "max(...)" try "rangemax(...)"
Take a look at function: rangemax( expr1 [ , expr2, ... exprN ] )
So in your case try: rangemax(Max([Net Long Position]),Max([Net Short Position]))
Thanks for your replies but it still doesnt work.
I cant post the file because im open in server.
Hi Use below functions
rangemax (1,2,4) returns 4rangemax (1,'xyz') returns 1
Yes that's it thanks. Its working now.