All you have to do is create a pivot table in qlikview from Layout -> Newsheet object -> chart -> click on pivot
Assign the Dimension as Time, Item_ID, Item_type and expression as sum(Item_Value)
After you click on finish.
Drag Item_type column to the top.
Hope this will help you
thanks for your fast answer. While the values appears in a simple tablebox I miss them in the pivot table.
When I create a Pivot table only the first dimesion as headerline is shown (Time), but nothing else. It looks like this:
Pivot Print Icon | Excel Icon | ...
Thats all. Pivot is the name of the diagramm object. I simple assigned the dimensions and clicked on finish. This is strange I did not ran in the problem before. Do I misunderstand the Pivot Diagramm? The values are based on a simple table.
You can achieve the result you specified with a pivot table, using a cross tabulation.
Create the pivot with Time, Item_ID and Item_type as dimensions, and Item_Value (or Sum(Item_Value) etc...) as the expression. Select the "Always Fully Expanded" option on the Presentation tab, and click OK. Click the header for Item_type and hold the mouse button down - you will see a blue vertical arrow line. Drag this to near the top right corner and it will convert to a horizontal blue arrow. Now release the mouse button.
Hope that helps.
Edit: pipped at the post by Kaushik