This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a dimension "Area ID" which branches into 4 departments: "ASM", "BIW", "C-2", and "PNT"..... I want to REPLACE "ASM" with "TCF", CHANGE "C-2" & "PNT" to "PAINT", and keep "BIW".... Is this possible through an expression? Thanks in advance.
May be use a calculated dimension or make changes in the script using if statements:
If([Area ID] = 'ASM', 'TCF',
If(Match([Area ID], 'PNT', 'C-2'), 'PAINT', [Area ID]))
If(Match([Area ID], 'PNT', 'C-2'), 'PAINT', [Area ID])) as [Area ID]
View solution in original post
Try using like this in your script for [Area ID]...
pick(match([Area ID],'ASM','BIW','C-2','PNT'),'TCF','BIW','PAINT','PAINT') as [Area ID]
Try using like this in your dimension for [Area ID]...
No problem at all