Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

Horizental above

Hi all,

i have a pivot table  with the  dimension  

Ordertype

A

B

so now i draggared to top 

the result coming as 

Ordertype     A     B

instead of this i want as

Ordertype

A     B

how can i do this?

Tags (1)
21 Replies
arvind_patil
Valued Contributor III

Re: Horizental above

Hi Sony,

Create Dummy Dimension 

_DummyDim:

Load * Inline[

_OrderType

Ordertype

];

DATA:

Load * Inline [

Ordertype

A

B

];

Add in pivot table you will get as you want.

Thanks,

Arvind patil

soniasweety
Valued Contributor III

Re: Horizental above

if i use the dimension how it will show in pivot table as that  way ?

soniasweety
Valued Contributor III

Re: Horizental above

for examplehort.PNG

year i have   

year  2010 2011 2012

now i want

      year

2010   2011 2012

arvind_patil
Valued Contributor III

Re: Horizental above

Hi Sony,

I think  You need to use year as column only.

and Customer as row .

Thanks,

Arvind Patil

balabhaskarqlik
Honored Contributor

Re: Horizental above

I don't think so, value will come like that.

arvind_patil
Valued Contributor III

Re: Horizental above

Create dummy dimension  _Year with value Year and use it as row

Thanks,
Arvind Patil

soniasweety
Valued Contributor III

Re: Horizental above

its not working

soniasweety
Valued Contributor III

Re: Horizental above

any other alternate for this?

arvind_patil
Valued Contributor III

Re: Horizental above

She will get extra column like year but value is null in that.

Thanks,

Arvind Patil