topic Grouping issue in QlikView

Grouping issue

Fri, 31 Dec 2010 07:15:28 GMT

Hi,

I know that we can group the columns using the gruoping functionality available in the document settings.

But when i click the first column then it is taking me to the second column any how i am not able to see the first column.

What i need to do is, to give the user +/- to expand and collapse the column details.

Ex: I have two columsn SBU and BU. Fist i should show all the SBU's with a Plus (+) sign against each of the SBU. If i click an SBU then i should get the list of BU's related to that SBU. The symbol must be (-) here. I should be able to see both SBU and BU at this selection.

Any suggestions is much appreciated.

Thanks,

Srihari.

Grouping issue

Fri, 31 Dec 2010 08:34:29 GMT

Hi,

If my understanding is correct. You can use the pivot table to get the desired result.

Grouping issue

Fri, 31 Dec 2010 12:35:17 GMT

I am using pivot table only.

But i am getting both of these columns side by side when both the columns are added as dimensions.

Thanks,

srihari

Grouping issue

Mon, 03 Jan 2011 05:38:29 GMT

Please attach the QVW file for more clarity

Grouping issue

deepakk — Mon, 03 Jan 2011 05:57:56 GMT

hi Srihari,

There two ways of grouping in qlikview. One is the Grouping in Dosument setting which will create a cyclic group or a Drill down.

When you create Drill down, the field which you have added first will be shown first in the dimension. When you select the data it will take you to the mext level of the data for that particular selection.

As per my understanding, In you case you need not create a drill down.

You can directly add the two fields in the dimension and use pivot table to achieve the + - .

When you right click a pivot table , you will find option like collapse / expand which will help you to drill down.

I hope this helps.

Grouping issue

Mon, 03 Jan 2011 06:07:10 GMT

Hi Deepak,

Yes that works... I am just selecting the pivot table in the fast change. 🙂

Its working after selecting the chart type in the left pane.

Thanks,

Srihari.