topic Re: Using field names as pivot table in QlikView

Using field names as pivot table

Fri, 28 Jun 2013 21:49:58 GMT

I have an idea of essentially turning a straight table into a pivot table, but by using conditional dimensions. This should give the user the ability to see their data by different dimensions by toggling on or off a column. What I'm trying to do is first create a list of all of my fields by using a list box object with $Fields as the dimension. Then, in my straight table I put the needed dimensions and add a condional as "=if(GetFieldSelections($Field)='FieldName', 1,0)".

My problem is that this only currently allows me to toggle one column at a time, where I would love to be able to select multiple fields in my list and allow the user to decide which columns to show. By using IF statements in the conditional, I would have to write a complex script for each dimension and I imagine this could be very resource intensive. Is there a better way to do this?

Re: Using field names as pivot table

stephencredmond — Fri, 28 Jun 2013 22:09:48 GMT

Hi,

Try something like this:

Match('Field2', $(=Chr(39) & Replace(GetFieldSelections($Field), ', ', chr(39) & ',' & chr(39)) & chr(39)))

'Field2' is the name of the field that you are testing for.

BTW, rather than use $Field, I might load a separate field with the list of fields that I want the user to select.

Regards,

Stephen

Stephen Redmond is author of QlikView for Developer's Cookbook
He is CTO of CapricornVentis a QlikView Elite Partner. We are always looking for the right people to join our team.
Follow me on Twitter: @stephencredmond

Re: Using field names as pivot table

Gysbert_Wassenaar — Sat, 29 Jun 2013 07:38:18 GMT

See the Build Your Report option in the attached example. It uses the substringcount function instead of match, but there are more ways to skin a cat.

Re: Using field names as pivot table

Mon, 01 Jul 2013 21:54:56 GMT

Thank you very much for this! It's exactly what I was looking for, and I'm glad there was a much simpler solution that what I first planned.