Suggest a meaningful UI

[#1]

Please suggest a meaningful UI representation of attached data.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8877.data.xls:550:0]

[suniljain]

you can represent this data in bar chart . comparison will be clearly shown in bar chart through bars.

[#3]

Can you please suggest sample .qvw file.

Please provide the .qvw file which can be opened in personal edition of qlikview.

[suniljain]

you can't open .qvw in personal addition.

[#5]

Not sure why .qvw files can't be opened in personal edition !!!

In personal edition I'm creating .qvw files only.

[martinpohl]

to load data:

Data:

CrossTable

(Month, Value, 3)

LOAD

Region ,

Geography,

Category,

[JAN 2009],

[FEB 2009],

[MAR 2009],

[APR 2009],

[MAY 2009],

[JUN 2009],

[JUL 2009],

[AUG 2009],

[SEP 2009],

[OCT 2009],

[NOV 2009],

[DEC 2009]

FROM

C:\Temp\Qlikview\Support\8877.data.xls

(biff, embedded labels, table is Sheet1$, filters

(Replace(1, top, StrCnd(null )),

Replace(2, top, StrCnd(null ))));

create a bar chart, dimension e.g month and as formula sum(value)

Regards