topic Re: Populating a column with the specific value of an expression in Insight Advisor

Populating a column with the specific value of an expression

tripod6999 — Thu, 19 Oct 2023 15:15:43 GMT

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

Re: Populating a column with the specific value of an expression

Sivapriya_d — Thu, 19 Oct 2023 16:12:36 GMT

Hi,

Max and total combination seems to be working ?

Thanks,

Re: Populating a column with the specific value of an expression

maheshkuttappa — Thu, 19 Oct 2023 16:14:54 GMT

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

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

Re: Populating a column with the specific value of an expression

tripod6999 — Fri, 20 Oct 2023 08:08:50 GMT

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

Re: Populating a column with the specific value of an expression

tripod6999 — Fri, 20 Oct 2023 10:44:51 GMT

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