topic Re: How to develop pivot table that you can expand it vertically not horizontally ? in QlikView

How to develop pivot table that you can expand it vertically not horizontally ?

wallacechen — Tue, 17 Apr 2018 09:31:54 GMT

Hi ,

I tried and see example as attached qvw. It is all expand qlikview pivot table horizontally to drill down different variables.

Is it possible we can expand qlikview pivot table VERTICALLY to drill down different variables as follows:

Thanks,

Re: How to develop pivot table that you can expand it vertically not horizontally ?

sunny_talwar — Tue, 17 Apr 2018 11:12:52 GMT

Something like this?

Re: How to develop pivot table that you can expand it vertically not horizontally ?

wallacechen — Tue, 17 Apr 2018 12:57:53 GMT

Hi Sunny,

The idea is that for example initially only show material variable in first column and first row with its value in second columns with rows onward , and then when you click + next to material in the same column. Material this column will be split from one row into multiple rows for material and models. so it will become

in first column and first row is material. in first column and 2nd , 3rd rows are model A and Model B under material.

second column with rows will be values for material (aggregation of model A and model B) and Model A and Model B and so on so forth.

So is it possible pivot table object has this functionality in qlikivew ?

Thanks ,

Wallace

Re: How to develop pivot table that you can expand it vertically not horizontally ?

marcus_sommer — Tue, 17 Apr 2018 13:53:20 GMT

You could use a pivot in QlikView to display these informations but I don't think you could get this layout like in your screenshot within a pivot.

You might get a bit near to this kind of tree-structure if you offset each lower level with a few spaces like it's often done in balance-charts and then controlling their visibility over your selections but the efforts for it would probably quite expensive and I'm not sure that the result wouldn't have one or two disadvantages and would satisfy your aim in the end. Therefore I suggest to find other views for it and maybe there which with a better readability like this from your screenshot.

- Marcus