Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

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
Honored Contributor III

Re: how to get max,min volume

Try:

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

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

kunkumnaveen
Contributor III

Re: how to get max,min volume

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

shraddha_g
Honored Contributor III

Re: how to get max,min volume

you are getting output for Max Expression?

kunkumnaveen
Contributor III

Re: how to get max,min volume

No I am getting either of them

kunkumnaveen
Contributor III

Re: how to get max,min volume

Sorry I am not getting either of them

shraddha_g
Honored Contributor III

Re: how to get max,min volume

can you share sample app?

kunkumnaveen
Contributor III

Re: how to get max,min volume

Any More Suggestion regarding the above requirement plz

Community Browser