How to tag records through Qlikview scripting?

Tue, 26 Feb 2013 01:41:15 GMT

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 NUMBER	ITEM NUMBER
KIT001	ITEM001
KIT001	ITEM002
KIT001	ITEM003
KIT001	ITEM004
KIT001	ITEM005
KIT002	ITEM001
KIT002	ITEM002
KIT002	ITEM003
KIT002	ITEM004
KIT003	ITEM003
KIT003	ITEM004
KIT003	ITEM005

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

ITEM KIT NUMBER	ITEM NUMBER	TAG
KIT001	ITEM001	MOTHER
KIT001	ITEM002	MOTHER
KIT001	ITEM003	FREE
KIT001	ITEM004	FREE
KIT001	ITEM005	FREE
KIT002	ITEM001	MOTHER
KIT002	ITEM002	MOTHER
KIT002	ITEM003	FREE
KIT002	ITEM004	FREE
KIT003	ITEM003	MOTHER
KIT003	ITEM004	MOTHER
KIT003	ITEM005	FREE

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

Regards,

Bill Ringer A. Salalima

Re: How to tag records through Qlikview scripting?

nagaiank — Tue, 26 Feb 2013 02:24:18 GMT

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

Re: How to tag records through Qlikview scripting?

Tue, 26 Feb 2013 03:15:17 GMT

Hi Kris,

Wow! This is great.

Thanks for the help.

Regards,

Bill

topic Re: How to tag records through Qlikview scripting? in QlikView

How to tag records through Qlikview scripting?

Re: How to tag records through Qlikview scripting?

Re: How to tag records through Qlikview scripting?