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: 
Not applicable

How to tag records through Qlikview scripting?

Hi,

Good day!

I have this instances, in one item kit number, it composes of 3 or more item number or items. What I want is to tag them that 3 of them are mother SKU and the rest are free. See example below:

IN THE TABLES BELOW, SAY THAT IT IS ALREADY SORTED PER KIT NUMBER PER ITEM NUMBER... What I want is to tag them per KIT NUMBER, that first TWO ITEMS are MOTHER, and the rest of the items are FREE. How to do the tagging through Qlikview scripting?

ITEM KIT NUMBERITEM NUMBER
KIT001ITEM001
KIT001ITEM002
KIT001ITEM003
KIT001ITEM004
KIT001ITEM005
KIT002ITEM001
KIT002ITEM002
KIT002ITEM003
KIT002ITEM004
KIT003ITEM003
KIT003ITEM004
KIT003ITEM005

AS RESULT. BELOW SHOULD BE THE FINAL RESULT OF THE TAG.

ITEM KIT NUMBERITEM NUMBERTAG
KIT001ITEM001MOTHER
KIT001ITEM002MOTHER
KIT001ITEM003FREE
KIT001ITEM004FREE
KIT001ITEM005FREE
KIT002ITEM001MOTHER
KIT002ITEM002MOTHER
KIT002ITEM003FREE
KIT002ITEM004FREE
KIT003ITEM003MOTHER
KIT003ITEM004MOTHER
KIT003ITEM005FREE

I hope anyone can help me with this. I need this as client per request. Thanks in advance.

Regards,

Bill Ringer A. Salalima

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

One way of achieving the result is in the attached solution. Hope this helps.

View solution in original post

2 Replies
nagaiank
Specialist III
Specialist III

One way of achieving the result is in the attached solution. Hope this helps.

Not applicable
Author

Hi Kris,

Wow! This is great.

Thanks for the help.

Regards,

Bill