How to do this?

[gauthamchilled]

Country  States           Rate

India      Delhi              5%

India       Mumbai          10%

India       Kerala               3%

To something like below in a pivot or straight table

India            Rate

  Delhi           5%

  Mumbai       10%

   Kerala          3%

[jagan]

Hi,

It is not possible in Qlikview, the alternative solution for this layout you can use Pivot Table

Dimensions : Country, State

Expression: Only(Rate)

Please find attached file, at most this is possible.

Hope this helps you.

Regards,

Jagan.

[gauthamchilled]

Jagan,

Country and State are two columns in your pivot. What I want is under India, same column want to bring the cities or states. how can I do that?

[ankitbisht01]

you should use hierarchy's then make Hierarchy's

[gauthamchilled]

ankit,

how to use hierarchy's before making Hierarchy's? 

[jagan]

Hi Gautham,

This is not possible.

Regards,

Jagan.

[ankitbisht01]

mistakenly wrote that i mean to say check if Hierarchy's can solve your problem

[qlikmsg4u]

Hi Gautham,

It may not be the correct solution but I give it a try.

[jagan]

Hi,

Please find attached file, hope it helps you.

Regards,

Jagan.

[avinashelite]

Hi Gautham,

Pivot table is the closest option you can use , getting the data with the same column is not possible

[alexandros17]

This is my example