topic Re: Pivot Table with imported data in QlikView

Pivot Table with imported data

Sat, 28 Dec 2013 12:39:33 GMT

All,

I have List Tables at hands (imported data). I would like to make a pivot table with four columns: portfolio, rev 2011, rev 2012, rev 2013. I choose these 4 fields as the 4 dimensions in the dimensions tab.

All I get is a single row single column table with the header 'portfolio'. I enclose the dimension tab as i filled it and the table pivot i get.

I fear this is because i should not have 4 dimensions here but only 1, portfolio. then other 3 fields are not 'dimensions' because they are not subcomponents of portfolio. is that correct ?

What is wrong ?

Re: Pivot Table with imported data

bbi_mba_76 — Sat, 28 Dec 2013 17:01:41 GMT

Hi,

it is better if you could attach the qvw file.

I suppose there are no expressions in your chart, and suppress missing and suppress zero values are marked. Could you try to add a simple expression, like 1, or unmark the suppressing options?

Re: Pivot Table with imported data

qlikpahadi07 — Sun, 29 Dec 2013 09:37:14 GMT

Try to attach a Sample