topic Re: Cross Table in QlikView

Cross Table

Fri, 09 Jan 2015 15:00:54 GMT

real time scenarios to use cross table.

Re: Cross Table

kiranmanoharrode — Fri, 09 Jan 2015 15:02:42 GMT

Pivot table excel data...

Re: Cross Table

Fri, 09 Jan 2015 15:08:19 GMT

Hi Pram,

do a search on the community and you will find many examples of crosstable questions for a range of scenarios.

It is also worth have a read of this

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

hope that helps

Joe

Re: Cross Table

Fri, 09 Jan 2015 15:17:50 GMT

Hi,

Cross tables can be used in scenarios You have many Columns which can be clubbed into a single column..

Example;Sales for Months for Listed City; In this scenario I have just taken 3 Months ; you can imagine the reduction of Columns in other such scenarios.

City	Jan	Feb	Mar
Delhi	50	30	20
Mumbai	60	100	20
Bangalore	100	20	60

After Cross Table :

City	Month	Sales
Delhi	Jan	50
Mumbai	Jan	60
Bangalore	Jan	100
Delhi	Feb	30
Mumbai	Feb	100
Bangalore	Feb	20
Delhi	Mar	20
Mumbai	Mar	20
Bangalore	Mar	60

Hope it helps !

More info on : http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

Cheers !

Re: Cross Table

Fri, 09 Jan 2015 15:46:46 GMT

Thanks for your detailed explanation with screenshot.

Re: Cross Table

Fri, 09 Jan 2015 15:47:07 GMT

Thanks for sharing link

Re: Cross Table

Fri, 09 Jan 2015 15:52:01 GMT

no problem, the community is awash with useful information, just need to search for it