Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table Buckets issue?

HI All,

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...?

Regards,

Helen

8 Replies
colin_albert

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.

Not applicable
Author

HI colin,

I have dragged the Expression column Under buckets, Then Entire Expressions are Moving into Column...

O/P for Example like this:

Exampleee.JPG

regards,

Helen

colin_albert

Can you post a screen shot of what you are trying to achieve?

Not applicable
Author

I have added Some buckets, Like this...

Exampleee.JPG

colin_albert

Hi Helen,

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.

Not applicable
Author

OK, I will create Separate chart for Other Expressions..

But I want to Supress One Expression Which is coming zero, Whether it is possible...

Regards,

Helen

MarcoWedel

Hi,

can you post your solution so far to look for the issue?

regards

Marco

Not applicable
Author

Is it Possible to Sum up the Total Stock QTY & Total Stock Value  ..In a Separate column SO that I can identify tis much QTY has done aging....

help required....