Column Spliting in Qlikview expression

[#1]

I have requirement to split the column based on Code type. My pivot table should has 4 dimension and 1  measure.

Dimensions

1 ) Number

2) Source Name

3) Destination Name

4) Code Type

5) Split Column

Measure

Volume

Number	Source Name	Destination Name	Code Type	Split Column1	Split Column2	Split Column3	Sum(Volume)
1	SRC1	DEST1	01	ABC			1234
1	SRC1	DEST1	02		DEF		456
1	SRC1	DEST1	03	ABC		PQR	789

Please note split column is only one column in database and there are scenarios that for 1 Number we could have Code type 01 and 03

and when have Code Type 03, I do not want to display the value present for Split column 1. Please let me know how I can make split column1 not to display any value if we have split column3

Thanks,

Mithun

[nagaiank]

Attached application  has a way of achieving what you want.

[#3]

Thanks for the response. Sorry to miss another point here that on source side we actually have 2 different rows if we have different code type.

Thanks,

Mithun