topic Re: Expressions across Rows and Columns in QlikView

Expressions across Rows and Columns

Wed, 21 Oct 2015 07:46:18 GMT

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

Re: Expressions across Rows and Columns

datanibbler — Wed, 21 Oct 2015 07:54:08 GMT

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

Re: Expressions across Rows and Columns

rwunderlich — Wed, 21 Oct 2015 07:54:21 GMT

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

-Rob

Re: Expressions across Rows and Columns

Wed, 21 Oct 2015 08:03:42 GMT

Put a table into original post

Re: Expressions across Rows and Columns

HirisH_V7 — Wed, 21 Oct 2015 12:33:40 GMT

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