topic One heading for two dimensions in pivot table in QlikView

One heading for two dimensions in pivot table

Mon, 19 Mar 2012 11:56:46 GMT

I'm trying to create one heading for two dimensions in a pivot table. I've attached the model. Above the dimensions

1)0-5,

2)6-9,

3)>10

I want to put a heading,Thresholds - like a merged cell.

For now I've left those headings blank

A graphic representation of what I would like to do.

TESTCategories	TESTMetric	TESTDescription	Thresholds			sum(Amount)
Clients	Limits	Information on number of incidences	1) 0-5	2) 6-9	3) >10	12

Any ideas?

Mon, 19 Mar 2012 12:11:02 GMT

Hi,

0-5, 6-9, >10 etc. must be same field (range of days, months etc.)

We can create such ranges for same field.

Then, u will get Common Heading for 3 difft columns.

I don't know if u hv specific requirement for creating 3 independent columns for this.

Mon, 19 Mar 2012 12:21:31 GMT

Ho would I do the common heading. If I do what you suggest then the thresholds 0-5,6-9,>10 appear in a column, as per attached model

jagan — Mon, 19 Mar 2012 12:51:41 GMT

Hi,

You can use the Concat() as Calculated Dimension. Check the attachment for solution, is that you require.

Hope this helps you.

Regards,

Jagan.

Mon, 19 Mar 2012 13:00:28 GMT

Thanks, that helps!!