topic grouping in edit script in QlikView

grouping in edit script

Surya — Sat, 16 Nov 2024 04:33:44 GMT

I have a 2 fields i need to grouping in edit script

field names are Material and finishing days

in the material the material code like 6-10 ,6-9,6-13,10-13 like

and finishing days 1-1000

here i want grouping

material other than 6-10 and days >30    //one group

material other than 6-9 and days >30     //one group

material other than 6-10 and days <=30    //one group

material other than 6-9 and days <=30     //one group

material has 6-9    //one group

material other than 6-9    //one group

How can i do
the two fields available in same table

Re: grouping in edit script

HirisH_V7 — Tue, 05 Feb 2019 06:21:34 GMT

Could you please post a sample data set and expected result.

Re: grouping in edit script

Surya — Tue, 05 Feb 2019 06:48:49 GMT

load *, if(NOT WILDMATCH(MATERIAL_LONG_INV,'*6-10*') AND FINISHING_AGEING_DAYS_INV >30,'STRSALES', if(NOT WILDMATCH(MATERIAL_LONG_INV,'*6-10*') AND FINISHING_AGEING_DAYS_INV <=30,'STRPLANT', if(WILDMATCH(MATERIAL_LONG_INV,'*6-10*') ,'STRGAUCTION'), if(NOT WILDMATCH(MATERIAL_LONG_INV,'*6-9*') AND FINISHING_AGEING_DAYS_INV >30,'MLSMASALES', if(NOT WILDMATCH(MATERIAL_LONG_INV,'*6-9*') AND FINISHING_AGEING_DAYS_INV <=30,'MLSMAPLANT', if(WILDMATCH(MATERIAL_LONG_INV,'*6-9*' ,'MLSMAUCTION')))))AS SP_GROUP