Expressions across Rows and Columns

[#1]

Hi,

Title probably doesn't make sense, but what I'm looking to do is having a chart with expressions going down and across e.g.

I have a count of policies and a count of members in two columns, and then multiple rows that are also expressions, so you'd have count of policies that match a certain criteria and right next to it, a count of members.

Is that possible or do I need to rewrite the code to get it to work?

Thanks

It'd be something like the below.I currently have the first two columns done, no dimensions, just all expressions. Ideally hoping there's a way to add in the extra column as a member count with the same criteria. Alternatively, if I can't do that, is there any way to make expressions clickable so that I could select the 49000 that are left and then in another chart, it'd show me out of those 49000, how many members are associated with those policies

Header 1	Header 2	Header 3
	Policies	Members
Total	200000	500000
Age Eligible	50000	150000
Group Eligible	1000	2000
Claim	100000	200000
Left	49000	148000

[datanibbler]

Hi Craig,

sounds quite like a crosstable to me?`Sure you can do that in QlikView - with a Pivot_table, you can have two dimensions and then drag one of the dimensions so that it runs horizontal.

I haven't really got any experience, never worked with Pivot_tables, but well, just try it out.

Best regards,

DataNibbler

[rwunderlich]

Could you provide a mockup of what it should look like? Like create a sample with mock data in excel?

-Rob

[#4]

Put a table into original post

[HirisH_V7]

Hi

Can You create a sample excel file with data may help your requirement.