Discussion Board for collaboration on QlikView Layout & Visualizations.
I'm trying to create one heading for two dimensions in a pivot table. I've attached the model. Above the dimensions
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.
Go to Solution.
You can use the Concat() as Calculated Dimension. Check the attachment for solution, is that you require.
Hope this helps you.
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.
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
Thanks, that helps!!