Merge 2 columns in a pivot table

[AnushaKarthik]

Hi all,

Is it possible to get the below format in qliksense pivot table?

	Current Month		Current Week
	Value	Qty	Value	Qty
Opportunities Created
Opportunities Converted
Opportunities Lost
Conversion Rate

[Or]

Assuming that "Current Month" and "Current Week" are values in a dimension, it should be trivial.

If they are not, you would need to create a synthetic dimension (either load it inline in script or use ValueList()) and then adjust your measures so they calculate a different formula depending on which dimension value they're associated with.

e.g. ValueList('Week','Month') for a dimension

if(ValueList('Week','Month') = 'Week', Sum(FieldA),Sum(FieldB)) for a measure

[AnushaKarthik]

But what to do for the conversion rate? It should merge current week and current month..

[Or]

Ah, I didn't realize that was intentional. In that case, unfortunately this is not something you can do.

[Mark_Little]

Hi there,

As @Or has siad this is not possible in QlikSense. 

You could create a report in the NPrinting that would look like that. 

[AnushaKarthik]

ok. Thank you so much