Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mato32188
Specialist
Specialist

Iteration over ID

Hi guys,

I would like to ask you to find very quick and clean solution to populate column InteractionCycleID in script as shown based on Interaction column.

Thank you.

BR

Martinimg.png

 

 

ECG line chart is the most important visualization in your life.
Labels (1)
1 Solution

Accepted Solutions
mato32188
Specialist
Specialist
Author

Ok.

I have found solution using intervalmatch with applymap(ID&ValidFrom&ValidTo,ID,null()) to original table.

 

ECG line chart is the most important visualization in your life.

View solution in original post

5 Replies
martinpohl
Partner - Master
Partner - Master

create a new expression

max(total <ID> Interaction)

Regards

mato32188
Specialist
Specialist
Author

Hi Martin,

thank you. As mentioned above, I need that operation to be done in script, not by table object in GUI.

BR

M

ECG line chart is the most important visualization in your life.
martinpohl
Partner - Master
Partner - Master

so in script:

left join (tablename)

load

ID,

max(Interaction) as IDInteraction

resident table 

group by ID;

mato32188
Specialist
Specialist
Author

Hi Martin,

thank you for an answer. Unfortunately your solution does not help as ID contains potentially more than one Interaction.

BR

Martin

 

ECG line chart is the most important visualization in your life.
mato32188
Specialist
Specialist
Author

Ok.

I have found solution using intervalmatch with applymap(ID&ValidFrom&ValidTo,ID,null()) to original table.

 

ECG line chart is the most important visualization in your life.