topic Data profiling in QlikView

Data profiling

Mon, 10 May 2010 19:45:22 GMT

Hi,

in marketing, we generate chart to compare 2 groups (say G1 & G2) with a lot of numeric fields :

Field G1 G2

F1 avg(F1) avg(F1)

F2 avg(F2) avg(F2)

F3 count(F3) count(F3)

....

My question is it possible to transpose a straight chart (with 2 rows & N columns) in a table with 3 columns & N rows ?

I know I can accomplish with a transposition of my data in the script, but I wonder if it's possible directly in chart.

Any ideas ?

johnw — Mon, 10 May 2010 19:57:06 GMT

I may not be understanding, but properties -> presentation -> horizontal?

Mon, 10 May 2010 20:06:07 GMT

ty John, I've never seen the option !

Mon, 10 May 2010 21:23:36 GMT

John says properties -> presentation -> horizontal

This is OK, buy try with simple table chart.

Best Regards.