topic Re: How can i get the row values as a dimension from a table in QlikView

How can i get the row values as a dimension from a table

Thu, 07 May 2015 05:37:22 GMT

Dear Friends ,

How can I use the dimension as a row values

Ex:

Year Country

India AUS USA

2000 45 60 87

2001 48 84 89

By using this above ex I wanna use Year Country as a dimension is it possible pls help me........

Re: How can i get the row values as a dimension from a table

Thu, 07 May 2015 05:44:43 GMT

Hi abinesh,

You can use crosstable concept here.

While loading excel file, by clicking on enable transformation step you can do this.

Hope this helps.

Susvith

Re: How can i get the row values as a dimension from a table

sunilkumarqv — Thu, 07 May 2015 05:47:15 GMT

HI Abinesh

Use cross table

if ur data is like

Year	India	Aus	USA
2000	45	60	87
2001	48	84	89

in scrip

CrossTable(Country, Data)

LOAD Year,

India,

Aus,

USA from data source

Re: How can i get the row values as a dimension from a table

sunilkumarqv — Thu, 07 May 2015 05:48:16 GMT

Hi check attached

Re: How can i get the row values as a dimension from a table

avinashelite — Thu, 07 May 2015 05:49:46 GMT

Hi Abinesh,

Try with cross table and transpose the columns according to your need. If your facing any issues, please share the sample file with data. So that we can help you out on the same.

Re: How can i get the row values as a dimension from a table

Thu, 07 May 2015 07:18:11 GMT

bro thanks ur rsp if my table look like as below means

Year India AUS USA

TN AP Delhi GT ER TY CL UI OP

2000 45 60 87 56 87 54 78 98 32

2001 48 84 89 78 98 21 45 21 31

I need dimension as Country name as well as State name and my pivot table look should be look like as above at the same time my datasource also same like as above

Re: How can i get the row values as a dimension from a table

help4qv123 — Thu, 07 May 2015 07:27:23 GMT

Hi,

You can pull in two ways...while pulling 1st transpose state with year later apply cross table from country. u wil get the output.

Re: How can i get the row values as a dimension from a table

jonathandienst — Thu, 07 May 2015 07:34:11 GMT

See my post in this thread Cross table for an example of loading data in that format.