Populating a column with the specific value of an expression

[tripod6999]

Hi everyone,

This might be an easy solution, but I am relatively new to QlikView. I would basically like to populate a fourth column with the highest value given in the sales column (733 here) which was evaluated by using an expression such that the fourth column looks like that below. How can I do that using an expression. I have tried using a combination of MAX, AGGR, TOTAL, etc, but to no avail! 

Thanks.

Year	Department	Sales	Highest Sales Value
2022-23	A	626	733
2022-23	B	516	733
2022-23	C	733	733
2022-23	D	550	733
2022-23	E	675	733
2022-23	F	574	733
2022-23	G	300	733
2022-23	H	22	733

[Sivapriya_d]

Hi,

Max and total combination seems to be working ?

Thanks,

[maheshkuttappa · Accepted solution]

This should work Max(Total Aggr(sum(Sales),Department,Year))

Sum(Sales) is the calculated measure.Add your calculated  measure 

[tripod6999]

Hi,

Thank you for that suggestion, but unfortunately it doesn't work. It appears the difficulty is that the sales figures is generated by an expression.

But thanks for your quick response. It's much appreciated.

Francis

[tripod6999]

Hi,

Thank you for your quick reply. Much appreciated. I got it to work with the following minor adjustment to your expression:

Max(Total AGGR(sum(Sales),Department))

Thanks again.

Francis