topic Re: Many to One String Values in Pivot in QlikView

Many to One String Values in Pivot

Sun, 13 Jul 2014 20:34:40 GMT

Hi - we are trying to represent a cross-table type view three dimensions. "Apps" are 1:1 to "Countries" but "Functional Services" (FS) can have many Apps.

e.g, each app belongs to 1 country but to many functional services, and FS's have many apps. You can use "concat" but the multiple values are all on one line - is there a way to break these out like in an embedded list/group or in separate rows?

Currently use:

This is the result of a standard pivot but multiple values are concatenated in one cell (e.g. ENG:FS1). Can they be listed (like a nested list?

Source data:

Thanks for any ideas!

Re: Many to One String Values in Pivot

tresB — Mon, 14 Jul 2014 10:40:40 GMT

Your source data is already row-wise. Did not really get your requirement point.

Re: Many to One String Values in Pivot

Mon, 14 Jul 2014 11:00:23 GMT

Hi - thanks - it's more about presentation - it needs to look like a heat-map (there will be colour formatting applied) with a horizontal dimension and vertical dimension and the results listed as cells rather than concatenated in one cell.

Re: Many to One String Values in Pivot

sujeetsingh — Mon, 14 Jul 2014 11:21:16 GMT

Drag the dimension to Horizontal view

Re: Many to One String Values in Pivot

Mon, 14 Jul 2014 11:34:02 GMT

thanks - the horizontal dimension is OK, just there are many string results per cell - they need to be concatenated as per top pic and we'd like separate cells, or an embedded list- I don;t think this is possible.