topic Need to show Two Dimensions as a one dimension in QlikView

Need to show Two Dimensions as a one dimension

Thu, 10 May 2012 05:36:44 GMT

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

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

Regards,

baru

suniljain — Thu, 10 May 2012 06:02:33 GMT

In this case you have to combine both dimention.

Like dimention1&'-'dimention2 as single dimention.

Thu, 10 May 2012 06:13:58 GMT

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