Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

how to get max,min volume

Hello All ,

               From the below table how to get these column

For

       MAX VOLUME= sum(MAX OF NUMBERS VOLUME) which is (045)  (-52+57)=5

       Min VOLUME= sum(MinOF NUMBERS VOLUME) which is (007)  (-5)=-5

      

Capture.PNG

But I need it in column wise as below

Capture1.PNG

thanks

7 Replies
shraddha_g
Partner - Master III
Partner - Master III

Try:

sum({<NUMBER = {"$(=max(NUMBER))"}>} VOLUME)

sum({<NUMBER = {"$(=min(NUMBER))"}>} VOLUME)

kunkumnaveen
Specialist
Specialist
Author

Thanks for quick reply ,but for some reason I am getting 0 as output when I  am using min volume expression

shraddha_g
Partner - Master III
Partner - Master III

you are getting output for Max Expression?

kunkumnaveen
Specialist
Specialist
Author

No I am getting either of them

kunkumnaveen
Specialist
Specialist
Author

Sorry I am not getting either of them

shraddha_g
Partner - Master III
Partner - Master III

can you share sample app?

kunkumnaveen
Specialist
Specialist
Author

Any More Suggestion regarding the above requirement plz