topic Re: How to show these data on a graph ? in QlikView

How to show these data on a graph ?

Thu, 23 Aug 2012 08:56:54 GMT

Hello,

In case 1 (blue), my data have a different representation than in case 2 (green).

I don't know how I could represent the data in case 2 in a graph, in a simple graph like in case 1. The representation should be the same...that's what I would like.

Thank you very much for your help!

Ivan

Re: How to show these data on a graph ?

swuehl — Thu, 23 Aug 2012 09:28:18 GMT

You can turn your crosstable into a straight table while loading in using a CROSSTABLE LOAD prefix.

Please check the CROSSTABLE LOAD prefix in the Help, I think your load statement might then look like

CROSSTABLE (Type, Zeit) LOAD

VertragID,

Beschaffungszeit,

Freigabezeit,

Publikationzeit,

Eingabezeit,

Publikationzuzeit,

Nachpublikationzeit,

Einspruchsfristzeit,

Zuschlag,

Vertragsabschlusszeit

FROM

test.xlsx

(ooxml, embedded labels, table is Tabelle2);

Then you can use your created Type field as dimension and sum(Zeit) as expression.

Re: How to show these data on a graph ?

Thu, 23 Aug 2012 11:19:39 GMT

Thank you!