Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jvk_sharma
Creator III
Creator III

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 II
Champion II

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

View solution in original post

4 Replies
vinieme12
Champion II
Champion II

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

View solution in original post

jvk_sharma
Creator III
Creator III
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 II
Champion II

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

jvk_sharma
Creator III
Creator III
Author

Thanks vineeth.

Perfect. Job done.