Need to show Two Dimensions as a one dimension

[#1]

Hello All,

I am new to QlikView.I have one requirement,i dont know it is possible or not in qlikview.

My requirement is i am having two dimensions,one is Region and second-one is products.

In Region                     In Products

    North                           Prod1

    South                          Prod2         

    Central                        Prod3......

I am using two charts,combo chart,Pivot table.i want to show these two dimensions as a one dimension in charts

ex:-

dimension1	dimension2	dimension3	dimension4		products	prod1	prod2	prod3	north	south	central
				target
				MTD
				YTD

like this i want to show in pivot table.Can any one have solution for this.Thanks in advance

Regards,

baru

[suniljain]

In this case you have to combine both dimention.

Like dimention1&'-'dimention2 as single dimention.

[#3]

Hello Sunil,

Thanks for your reply,

My requirement is to show two dimensions  in different columns.

Your solution is displaying prod1-central,prod2-north,...but i want to show the above formate.

regards,

baru