topic Re: grouping in QlikView

grouping

Fri, 18 Jul 2014 07:29:17 GMT

how can we convert this chart

into

Re: grouping

kaushiknsolanki — Fri, 18 Jul 2014 07:31:12 GMT

Hi,

You can change the sequence of the dimension.

In Dimension tab take Terminal on top and then second one should be business.

Regards,

Kaushik Solanki

Re: grouping

Fri, 18 Jul 2014 07:32:45 GMT

simply take a straight table. then get the desired result. hope this helps you.

Re: grouping

Fri, 18 Jul 2014 07:39:33 GMT

Thanks, but i tried that it result in

but i want that grand total should be display in the bottom. i.e.634.99 & i will not display 97.68 ,383.55,154.16

Can't we display the chart in same same format as required by user( as mentioned in excel attachment)

Re: grouping

Fri, 18 Jul 2014 07:41:26 GMT

how?

Re: grouping

Fri, 18 Jul 2014 09:39:12 GMT

plz reply asap

Re: grouping

Fri, 18 Jul 2014 09:49:49 GMT

Hi Sweta

Instead of using Pivot Table just click on straight table...

That should do the trick...

Re: grouping

Fri, 18 Jul 2014 09:51:23 GMT

Dear Shweta,

In the general tab of you pivot select straight table which appears below the pivot. Also looks like in your image you are sorting by terminal. If that is correct go to sort and promote terminal over business. This should give you what you want.

Regards

Rahul

Re: grouping

Fri, 18 Jul 2014 10:09:11 GMT

Yes !!, I got the solution

Using pivot table

take-terminal as 1st dimension then check show partial sum for both terminal and category & for terminal write grand total in label tab and for category write total in label