topic Re: Merging Cells with Common Contents In Straight Table in QlikView

Merging Cells with Common Contents In Straight Table

Thu, 09 Oct 2014 12:49:51 GMT

Hi Friends,

I am trying to use a straight table and want to merge cells with same values. Can this be done?

Attached is the example for your reference and below is the desired output format.

City	Month	Payment
		113820.25
London	Jan	933.75
	Feb	3093.75
	Mar	228.5
	Apr	622.5
	May	2062.5
	Jun	900.75
	Jul	1909.5
	Aug	17740.5
	Sep	17743.5
	Oct	342.75
	Nov	933.75
	Dec	228.5
New York	Jan	600.5
	Feb	1273
	Mar	11827
	Apr	11829
	May	228.5
	Jun	622.5
	Jul	2062.5
	Aug	900.75
	Sep	1909.5
	Oct	17740.5
	Nov	17743.5
	Dec	342.75

Thanks in advance.

Regards,

Re: Merging Cells with Common Contents In Straight Table

anbu1984 — Thu, 09 Oct 2014 12:55:12 GMT

Try Pivot table

Re: Merging Cells with Common Contents In Straight Table

sivarajs — Thu, 09 Oct 2014 12:56:18 GMT

Use pivot table in this case

Re: Merging Cells with Common Contents In Straight Table

Thu, 09 Oct 2014 12:59:43 GMT

Thanks for the response, however I will be adding Pick dimensionality for this table; as far as I know this is not possible using pivot tables

Re: Merging Cells with Common Contents In Straight Table

JonnyPoole — Thu, 09 Oct 2014 13:05:14 GMT

Its the default for a pivot table but see below to do this in a straight table. The key formatting technique is using the argb() color function . When the first parameter is 0 it indicates complete transparency.