Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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........

7 Replies
Not applicable

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

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.

BR

Susvith

sunilkumarqv
Valued Contributor II

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

HI Abinesh

Use cross table

if ur data is like

 

YearIndiaAusUSA
2000456087
20014884

89

in scrip

CrossTable(Country, Data)

LOAD Year,

     India,

     Aus,

     USA from data source

sunilkumarqv
Valued Contributor II

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

Hi check attached

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

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.

Not applicable

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

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

help4qv123
Contributor

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

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.

MVP
MVP

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser