topic Re: Field names as column headers in QlikView

Field names as column headers

Anonymous — Thu, 29 Jan 2015 23:03:43 GMT

All,

I am wondering if it's possible to take a data set and format it like I could in a pivot table in excel. With this data set in excel, it's very easy to put location as my Row Label, Revenue Type as my Column Header, and Revenues as my sum. Why can't I seem to do this in Qlikview?

Re: Field names as column headers

Thu, 29 Jan 2015 23:52:03 GMT

I'm not sure if I get what you're asking, but you can add labels for expressions, and therefore set the Field name to every expression (that'll be the column header).

Nevermind, after seeing the answer below I understood that you're looking for the field values to be the column headers. Yeah what Marco Wedel below me said is correct.

Re: Field names as column headers

MarcoWedel — Thu, 29 Jan 2015 23:53:04 GMT

Hi,

with "Revenue Type as Column Header" you mean the field values (not the field names like your thread title suggests), right?

If this is the case, then you're describing a classical pivot table.

After creating one in QlikView, just drag one dimension to the top as column header:

the result should look like:

hope this helps

regards

Marco

Re: Field names as column headers

Anonymous — Thu, 29 Jan 2015 23:59:00 GMT

That does it. Thanks Guys!

Re: Field names as column headers

MarcoWedel — Fri, 30 Jan 2015 00:00:15 GMT

You're welcome

regards

Marco

Re: Field names as column headers

Anonymous — Fri, 30 Jan 2015 00:09:46 GMT

Can the columns be moved? To use your example above, could you drag December in front of November?

Re: Field names as column headers

MarcoWedel — Fri, 30 Jan 2015 00:15:20 GMT

not by dragging, you would have to define a special sort order, e.g. an expression to sort by.

Re: Field names as column headers

MarcoWedel — Fri, 30 Jan 2015 00:27:14 GMT

one example:

=Match([Revenue Type], 'type 2', 'type 3', 'type 1')

would sort the Revenue Type columns in the defined order: 'type 2', 'type 3', 'type 1'

hope this helps

regards

Marco

Re: Field names as column headers

Anonymous — Fri, 30 Jan 2015 00:30:53 GMT

Sorry to keep pestering you - but any idea why I am not seeing any subtotals?

Re: Field names as column headers

MarcoWedel — Fri, 30 Jan 2015 00:39:59 GMT

No, not at the first glance.