topic Re: Data as column (Table) in QlikView

Data as column (Table)

Anonymous — Mon, 28 Jul 2014 14:12:26 GMT

Hello!

Is possible, turn some years as Columns?

I tried, but it failed.

Thanks !

Re: Data as column (Table)

Anonymous — Mon, 28 Jul 2014 14:17:17 GMT

Load your table as Cross table

Re: Data as column (Table)

Mon, 28 Jul 2014 14:17:48 GMT

Create as a pivot table, then drag the dimension up as a column

Re: Data as column (Table)

Anonymous — Mon, 28 Jul 2014 14:20:10 GMT

I tried, but it stays like this.

Re: Data as column (Table)

Anonymous — Mon, 28 Jul 2014 14:21:04 GMT

I tried, but it didnt work.

I think i need expression as dimension. Am i right?

Re: Data as column (Table)

MK_QSL — Mon, 28 Jul 2014 14:22:02 GMT

What is the dimension and expression you are using?

Re: Data as column (Table)

Anonymous — Mon, 28 Jul 2014 14:24:23 GMT

Dimension i'm using 'Year'.

And expression, 2 var%.

You can see it in the image, in first topic.

Thanks !

Re: Data as column (Table)

MK_QSL — Mon, 28 Jul 2014 14:25:40 GMT

what's wrong ? what you expect and what you getting?

Re: Data as column (Table)

Anonymous — Mon, 28 Jul 2014 14:29:11 GMT

I need to have the year 2011, 2012, 2013 and 2014 as column. And expressions as lines.

But it's not possible just using Cross Table and drag it to the right place.

Re: Data as column (Table)

MK_QSL — Mon, 28 Jul 2014 14:33:33 GMT

Do something like this.... don't know your exact column/Field name so giving suggestion using sample field..

Let we have Customer, Year and Sales as Field... You can use as below

Dimension

Customer

Expression

SUM({<Year = {'$(=Max(Year))'}>}Sales)

SUM({<Year = {'$(=Max(Year)-1)'}>}Sales)

SUM({<Year = {'$(=Max(Year)-2)'}>}Sales)

SUM({<Year = {'$(=Max(Year)-3)'}>}Sales)

Hope this helps...

Re: Data as column (Table)

Anonymous — Mon, 28 Jul 2014 14:40:40 GMT

The problem is :

-I have only 1 field as Dimension : Year

I dont have another Field to use as "Customer". So, i cant use the actual expression as Dimension, because i have 2 distinct expressions.

Re: Data as column (Table)

MK_QSL — Mon, 28 Jul 2014 14:54:09 GMT

Let me have your expressions...

Re: Data as column (Table)

Anonymous — Mon, 28 Jul 2014 14:58:10 GMT

=(count({<Segmento=(p ({$<Marca={'CHEVROLET'}>} Segmento))>}Numero_Chassis)/Below(count({<Segmento=(p ({$<Marca={'CHEVROLET'}>} Segmento))>}Numero_Chassis),-1))-1

=count(Numero_Chassis)/Below(count( Numero_Chassis),-1)-1

Re: Data as column (Table)

MK_QSL — Mon, 28 Jul 2014 15:00:19 GMT

have you got year field in your database?

Re: Data as column (Table)

tobias_klett — Mon, 28 Jul 2014 15:02:27 GMT

Hello
got to chart properties > presentation and mark "horizontal"

Re: Data as column (Table)

Anonymous — Mon, 28 Jul 2014 15:02:42 GMT

Yes !

Any idea?

Re: Data as column (Table)

Anonymous — Mon, 28 Jul 2014 15:04:32 GMT

Thank you !!!!

It worked !

Re: Data as column (Table)

MK_QSL — Mon, 28 Jul 2014 15:06:24 GMT

Create a Straight Table...

Don't keep any Dimension

Expression 1

=(count({<Year = {'$(=Max(Year))'},Segmento=(p ({$<Marca={'CHEVROLET'}>} Segmento))>}Numero_Chassis)/Below(count({<Year = {'$(=Max(Year))'},Segmento=(p ({$<Marca={'CHEVROLET'}>} Segmento))>}Numero_Chassis),-1))-1

=count({<Year = {'$(=Max(Year))'}>}Numero_Chassis)/Below(count({<Year = {'$(=Max(Year))'}>}Numero_Chassis),-1)-1

Same way use Year = {'$(=Max(Year)-1)'} and Year = {'$(=Max(Year)-2)'}