topic sum two max values in QlikView

sum two max values

t_hylander — Mon, 29 Oct 2018 14:56:07 GMT

Hi,

Im totally blank at the moment...and you are so often Quick

I've got a table;

year_month, Unit, Data

2018_01, Unit1, 251

2018_01, Unit2, 718

2018_02, Unit1, 257

2018_02, Unit2, 865

..and so forth

The Data-column is cummulative and what I want is to add these two into one in a simle text-object.

I tried like this, but it wont work;

max({<Unit={'Unit1'}>}Data) + max({<Unit={'Unit2'}>}Data)

Thanks in advance!

Re: sum two max values

sunny_talwar — Mon, 29 Oct 2018 15:05:57 GMT

You are looking to get 257 + 865 in a text box object?

Re: sum two max values

chrismarlow — Mon, 29 Oct 2018 15:08:03 GMT

Hi Tomas,

When you say not working, how do you mean? With your 4 lines as a dummy set I get 1122 in text box (does need an equals sign …), which does seem reasonable.

Cheers,

Chris.

Re: sum two max values

t_hylander — Tue, 30 Oct 2018 08:01:37 GMT

Ok, my bad...as I said my head was blank

It DOES work, however if I add a text infront it just gets blank.

='Total ' & chr(13) &

max({<Unit={'Unit1'}>}Data) + max({<Unit={'Unit2'}>}Data)

Re: sum two max values

chrismarlow — Tue, 30 Oct 2018 08:25:33 GMT

Maybe ='Total ' & ( max({<Unit={'Unit1'}>}Data) + max({<Unit={'Unit2'}>}Data))?