cREATING CUSTOm FIELDS IN QLikviEW

[qlikapple]

hI I  HAVE INCIDENTS WHICH ARE COMING FROM gROUOS CALLED

yeloo grOUP, greeNgROUP, redgROUP,bROWN gROUP, orANAGEgROUP, in which  i need custom field as

yeloo grOUP, greeNgROUP as Group1  redgROUP,bROWN gROUP as Group2 and others are unclassified groups

how to do that in qlikview

[Shubham_Deshmukh]

Which data source your are using?

[qlikapple]

oracle

[Shubham_Deshmukh]

Great!!
While using extraction script from data source, just use CASE WHEN for this.
Case
When gROUOS ='yeloo grOUP' OR gROUOS ='greeNgROUP ' Then 'Group1'
When gROUOS ='redgROUP' OR gROUOS ='bROWN gROUP ' Then 'Group2'
else 'Unclassified group'
end......

[qlikapple]

i dont want in form source, i want to do after qvd loading

[Shubham_Deshmukh]

Ok, hope you are using that groups as a dimension, then you need to use calculated dimension.

=PICK(WILDMATCH (groups,'yeloo grOUP', 'greeNgROUP','redgROUP','bROWN gROUP', '*'), 'Group1','Group1','Group2','Group2','Unclassified Group')

Again I will say, Case when will give you better performance.

 - Shubham D