Discussion Board for collaboration related to QlikView App Development.
I have created Buckets(0-3 Months,3-6 Months,6-9 Months,9-12 Months,1-2 Years,2-3 Years,3-4 Years) in Dimesion..
My Buckets are Working Fine..Here My concern is I have added Some more Expressions, but that Expressions are also coming under Buckets, I dont Want these ? it showl show Separate column..
How can I acheive this...?
Expand the pivot table to see the additional rows under your buckets, then click on the column and drag the rows to the column area of your chart. You should see a large blue arrow when you drag the rows.
You cannot achieve this in a single pivot table.
As you have found, all columns will be part of the pivot, so you will have The buckets above the Last 12 Months & Stock in Days columns. You will either need to create two charts, one for the buckets, the other of the Last 12 Months & Stock in Days data, or change your chart to a straight table.
Using a straight table you will have to create separate expressions for each column -
0-3Mths Qty, 0-3Mths Value, 3-6Mths Qty, 3-6Mths Value, Last 12 Mths, Stock in Days.
I would go for the straight table approach, you can still have an element of drill down by using a drill-down group as a dimension.