topic Re: How to create a crosstab at this scenario? in QlikView

How to create a crosstab at this scenario?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi ,

I need to create a crosstable I guess it is pivot table based on my requirement like

I have dimensions called 'Group_name', 'name', 'Date_selector', 'organisation'.

Once we select the group name we will get respective names like Contact Type, Name of school.etc;

so I need to display a table that shows like this based on the select of various organisations.

I am attaching the pic of 2 files.

Any help is highly appreciated.

vinieme12 — Fri, 27 Jan 2017 13:31:18 GMT

Not sure what the problem is here!!

Create a pivot table and drag date_selector field above the expression, you will see a blue line indicating the position

A sample would help

Anonymous — Fri, 27 Jan 2017 13:50:17 GMT

Hi Pujari,

Thank you it worked how you explained.

But how to avoid Totals in Name as it is calculating for every group name which is not required.

~But wanted the total like in the previos First Pic where you can see Total at the bottom.

vinieme12 — Fri, 27 Jan 2017 14:03:28 GMT

go to presentation tab and disable partial sums for "name" or "group_name" dimension and enable for MonthYear dimension

Anonymous — Fri, 27 Jan 2017 14:13:39 GMT

Thanks vineeth.

Perfect. Job done.