topic Suggest a meaningful UI in QlikView

Suggest a meaningful UI

Wed, 08 Dec 2010 10:39:47 GMT

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 — Wed, 08 Dec 2010 10:50:28 GMT

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

Fri, 10 Dec 2010 11:10:26 GMT

Can you please suggest sample .qvw file.

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

suniljain — Fri, 10 Dec 2010 12:08:43 GMT

you can't open .qvw in personal addition.

Mon, 13 Dec 2010 05:14:03 GMT

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

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

martinpohl — Mon, 13 Dec 2010 16:22:20 GMT

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