Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement in Qlikview where i need to display a pivot table with dimensions and some measures. But the 3rd dimension is combination of three dimensions, say Region, County, Business Unit. So i need to display all these three dimension values in the 3rd dimension in pivot table.
Kindly help me if it is possible in qlikview. if possible, kindly let me know how to do that?
Thanks,
Ramesh.
What do you mean with that combination of dimensions?
Note that you can create a new, concatenated dimension in the script or as calculated dimension in the chart
Dim1 & ' / ' & Dim2 & ' / ' & Dim3
All the 3 dimension values will display in a single dimension.
I could see the solution in some other post.
Qlikview Pivot Table Combine 2 Dimensions in Field
Thank you so much Stefan.
But now i am facing the problems with the coloring and Grouping. The first dimension in the grouping should have one color, the second dimension with some other color and 3rd dimension with some different color.
Could you please help me how to achieve this?
Could you provide a small sample application?
Please find the below data. I am unable to attach the file.
X | Y | Z | A | B | C | D | ||||
CIL Total | 4,511 | 5,622 | (2,013) | 0 | 3,610 | (60) | 3,550 | |||
G&O Total | 4,511 | 5,622 | (2,013) | 0 | 3,610 | (60) | 3,550 | |||
APAC | 1,134 | 1,005 | (597) | 0 | 408 | 0 | 408 | |||
India | 1,111 | 939 | (357) | 0 | 583 | 0 | 583 | |||
cognizant | 23 | 65 | (240) | 0 | (175) | 0 | (175) | |||
MiddleEAST | 671 | 1,519 | (409) | 0 | 1,111 | (40) | 1,071 | |||
Dubai | 297 | 919 | (178) | 0 | 741 | 0 | 741 | |||
tcs | 187 | 300 | (115) | 0 | 185 | (20) | 165 | |||
infosys | 187 | 300 | (115) | 0 | 185 | (20) | 165 | |||
North America | 187 | 300 | (115) | 0 | 185 | (20) | 165 | |||
USA | 187 | 300 | (115) | 0 | 185 | (20) | 165 | |||
South America | 2,519 | 2,798 | (892) | 0 | 1,906 | 0 | 1,906 | |||
Brazil | 297 | 919 | (178) | 0 | 741 | 0 | 741 | |||
Paraguay | 2,222 | 1,879 | (714) | 0 | 1,165 | 0 | 1,165 | |||
microsoft | 1,111 | 939 | (357) | 0 | 583 | 0 | 583 | |||
hewlett packard | 1,111 | 939 | (357) | 0 | 583 | 0 | 583 | |||
Brazil and Paraguay, India, Dubai and USA are from Region dimension | ||||||||||
Cognizant,tcs,infosys,microsoft,hewlett packard are from business unit dimension |
I need to see how you have created the mixed dimension and how your data model looks like.
If you followed what Sunny has proposed, you can used the Dim dimension to color the background.
I am using only one table from the database and this table has required fields for reporting.
I am facing problems while sorting this grouping dimension and i need to provide different background colors to each dimension in this group.