Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In this case you have to combine both dimention.
Like dimention1&'-'dimention2 as single dimention.
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