Merging Dimension and fact rows

Tue, 23 Nov 2010 23:01:43 GMT

Hi,

I have a chart in below format.My requirement is to merge the Pdt2 &Pdt3 in Product dimension and display it as Pdt2 and also the fact values should be summed up together.

Is it possible to do without script changes?

Category	Products	Qty1	Qty2	Qty3
Cat1	Pdt1
	Pdt2
	Pdt3
	Pdt4
Cat2	Pdt1
	Pdt2
	Pdt3
	Pdt4

Merging Dimension and fact rows

johnw — Tue, 23 Nov 2010 23:45:11 GMT

You might be able to replace the Products dimension with this:

if(Products='Pdt3','Pdt2',Products)

I think that will combine those two products into one, though I'm not certain.

topic Merging Dimension and fact rows in QlikView

Merging Dimension and fact rows

Merging Dimension and fact rows