Measurement value not correct until select the field

[Michael02]

Hello

I'm new to Qliksense and try to build a list table in Qliksense including some measurement. I'm facing a very strange issue which i can not figure out where it goes wrong.

I added one measurement field via expression, and it looks like when i do not click and select any field in 1st column and just let it shows all rows, the value in column no. 3 always show 0.

Replaced Part number	=Max([Repair Date])	=sum({<[Repair Date]={"$(=Max([Repair Date]))"}>} INC_MTR_REQUESTED_QTY)
201269Z00C	2022/11/28	2
2422000Z0H	2022/11/28	2
475119Z03C	2022/11/24	0

But once i manually click the number and select it, then result shows as below:

Replaced Part number	=Max([Repair Date])	=sum({<[Repair Date]={"$(=Max([Repair Date]))"}>} INC_MTR_REQUESTED_QTY)
475119Z03C	2022/11/24	8

I can not figure out why it act like this.

Can any of you give some advice?

Thanks in advance.

[Digvijay_Singh]

I think its happening because 475119Z03C has Max repair Date 11/24, its not the overall max date, less than the rest of the two. When you don't make any selection, it only shows measure value where you got max repair date.

When you make selections, 11/24 becomes the max repair data as you just got 1 record selected and it starts showing the measure value.

What if you change your expression to - 

Aggr(sum({<[Repair Date]={"$(=Max([Repair Date]))"}>} INC_MTR_REQUESTED_QTY),Replaced Part number)

Something like above but not sure if your objective is something else. 

[Michael02]

Thanks for quick reply.

I tried to update to above, and it looks like now there is no value show:

Replaced Part number	=Max([Repair Date])	=Aggr(sum({<[Repair Date]={"$(=Max([Repair Date]))"}>} INC_MTR_REQUESTED_QTY),INC_MTR_NO)
201269Z00C	2022/11/28	2
2422000Z0H	2022/11/28	2
475119Z03C	2022/11/24	-

[vinieme12]

Set Analysis is evaluated once per chart and not for each row

[Repair Date]={"$(=Max([Repair Date]))"}   << this will always return the maximum (Repair Date ) from the entire dataset

If you want to compare max Repair Date for each INC_MTR_NO then try below

= SUM( AGGR( if( [Repair Date] = Max(TOTAL <INC_MTR_NO> [Repair Date]) , INC_MTR_REQUESTED_QTY,0),INC_MTR_NO) )