Column Spliting in Qlikview expression

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Column Spliting in Qlikview expression

nagaiank — Fri, 26 Aug 2016 00:33:09 GMT

Attached application has a way of achieving what you want.

Re: Column Spliting in Qlikview expression

Fri, 26 Aug 2016 16:25:57 GMT

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

topic Re: Column Spliting in Qlikview expression in QlikView

Column Spliting in Qlikview expression

Re: Column Spliting in Qlikview expression

Re: Column Spliting in Qlikview expression