flag Max ID

[ZuzJsk007]

Hi folks, I'm fairly new to Qlik Sense and I would really appreciate help with following issue:

Let's image I have a table in my load script

Table:

LOAD * INLINE [

ID, Value   

1, A

2, B

3, C

4, D

];

I want to add a new column as a flag for max ID - so that I got a table like this:

Table:

ID	Value	Flag_MaxID
1	A	0
2	B	0
3	C	0
4	D	1

Thank you very much for any suggestions!

[Vegar · Accepted solution]

Try this solution. 

Table:

LOAD * INLINE [

ID, Value

1, A

2, B

3, C

4, D

];

Left join

Load max(ID) as ID,

1 as Flag_MaxID

Resident Table;

[ZuzJsk007]

Perfect!! Thank you so much!

[Vegar]

Glad to be of help.

Good luck with the rest of your project,