Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ZuzJsk007
Contributor III
Contributor III

flag Max ID

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:

IDValueFlag_MaxID
1A0
2B0
3C0
4D1

 

Thank you very much for any suggestions!

1 Solution

Accepted Solutions
Vegar
MVP
MVP

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;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Vegar
MVP
MVP

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;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

ZuzJsk007
Contributor III
Contributor III
Author

Perfect!! Thank you so much!

Vegar
MVP
MVP

Glad to be of help.

Good luck with the rest of your project, 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes