topic Re: how to get max,min volume in QlikView

how to get max,min volume

kunkumnaveen — Tue, 07 Nov 2017 06:36:00 GMT

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

But I need it in column wise as below

thanks

shraddha_g — Tue, 07 Nov 2017 06:38:43 GMT

Try:

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

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

kunkumnaveen — Tue, 07 Nov 2017 06:46:02 GMT

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

shraddha_g — Tue, 07 Nov 2017 06:54:13 GMT

you are getting output for Max Expression?

kunkumnaveen — Tue, 07 Nov 2017 06:56:09 GMT

No I am getting either of them

kunkumnaveen — Tue, 07 Nov 2017 06:56:43 GMT

Sorry I am not getting either of them

shraddha_g — Tue, 07 Nov 2017 06:58:48 GMT

can you share sample app?

kunkumnaveen — Tue, 07 Nov 2017 10:23:24 GMT

Any More Suggestion regarding the above requirement plz