Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to create a crosstab at this scenario?

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.services.png

services.png

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

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.

services.png

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

vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Thanks vineeth.

Perfect. Job done.