topic Re: Pivot table problem in QlikView

Pivot table problem

Anonymous — Fri, 31 Jan 2014 15:25:01 GMT

Hi frieds,

Please help with idea how to show many variable in one pivot table.

Please see below

I have variables Visit Frequency (tags: First visitor, Repeat visitor) and Age (tags: Under 25, 25-34 and ...)

I know only use Pivot table

Dimension: MYear

Expression: use set analysis for each tag

Thanks,

Re: Pivot table problem

giakoum — Fri, 31 Jan 2014 15:29:27 GMT

You can group some together, so that a pivot will be suitable. For example, group months by year and quarter.

Re: Pivot table problem

Anonymous — Fri, 31 Jan 2014 15:31:48 GMT

Could you explain more detail how to do it?

Thanks,

Re: Pivot table problem

giakoum — Fri, 31 Jan 2014 15:35:28 GMT

In your data model, using teh script, you can define the grouping by adding an inline table for example. or even better, use a calendar. So you would have a table looking something like this :

Month, Quarter, Year

Dec-2013, 2013Q4, 2013

Jan-2014, 2014Q1, 2014

etc.

Those new fields, Quarter and year could then be used as dimensions in your pivot.

Re: Pivot table problem

Anonymous — Fri, 31 Jan 2014 15:44:39 GMT

I don't have problem with MYear.

I don't know how to set up 2 other variable Visit frequency and Age.

It works well, when I use them in separate tables.

Dimension :MYear and Visit frequency

and another pivot table

Dimension: MYear and Age.

I don't know how to combine them in one pivot table.

When I add both them in Dimension, I get new level.

Re: Pivot table problem

giakoum — Fri, 31 Jan 2014 15:50:21 GMT

And so they should. if you want them in the same level, the values should belong in the same dimension. So maybe you should concatenate the 2 dimensions into one or create a new dimension combining the values of the 2, something like a link table.

Re: Pivot table problem

Anonymous — Fri, 31 Jan 2014 15:54:38 GMT

The problem variables have different total count

Re: Pivot table problem

giakoum — Fri, 31 Jan 2014 16:00:32 GMT

that can also be solved with if statement or set analysis

Re: Pivot table problem

Anonymous — Fri, 31 Jan 2014 16:02:36 GMT

how to combine all tags in one variable?

use crosstab?

Re: Pivot table problem

giakoum — Fri, 31 Jan 2014 16:04:07 GMT

please post a sample application if possible

Re: Re: Pivot table problem

Anonymous — Fri, 31 Jan 2014 16:13:14 GMT

Please find the file.