Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

One heading for two dimensions in pivot table

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.

TESTCategoriesTESTMetricTESTDescription      Thresholdssum(Amount)
ClientsLimitsInformation on number of incidences1) 0-52) 6-93) >1012

Any ideas?

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: One heading for two dimensions in pivot table

Hi,

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

Hope this helps you.

Regards,

Jagan.

4 Replies
Not applicable

One heading for two dimensions in pivot table

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.

Not applicable

Re: One heading for two dimensions in pivot table

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

MVP
MVP

Re: One heading for two dimensions in pivot table

Hi,

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

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: One heading for two dimensions in pivot table

Thanks, that helps!!

Community Browser