Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (1)
1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: How to tag records through Qlikview scripting?

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

2 Replies
nagaiank
Valued Contributor III

Re: How to tag records through Qlikview scripting?

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

Not applicable

Re: How to tag records through Qlikview scripting?

Hi Kris,

Wow! This is great.

Thanks for the help.

Regards,

Bill

Community Browser