topic Qlikview Data Table Structure in QlikView

Qlikview Data Table Structure

Fri, 24 Oct 2014 10:14:06 GMT

HI All ,

Can you please help me with , what is the best table structure for to build a report on Qlikview , How my Dimension and Measures should be arranged(in columns , rows ) , i find that it is good to have all dimensions in rows , so that we can do set analysis easily

is my perspective correct , kindly hep me with documentation on this perspective

Thanks,

Sai

Re: Qlikview Data Table Structure

trappersw — Fri, 24 Oct 2014 13:35:23 GMT

Your question is rather general, in my opinion it all depends on the hierarchies in the data you are modelling (fi: cities). With limited different dimensions with no hierarchical relation you could do it like you describe, otherwise I would suggest to use different columns for different hierarchically associated data (fi: continent, land, city)

Re: Qlikview Data Table Structure

markodonovan — Fri, 24 Oct 2014 13:39:40 GMT

Hi Sai,

To begin with have a look at this document which might help:

Best Practices for Data Modelling

Thanks

Mark

www.techstuffybooks.com

Re: Qlikview Data Table Structure

Fri, 24 Oct 2014 13:41:25 GMT

it will depend on how many Fact tables you have.

Re: Qlikview Data Table Structure

Colin-Albert — Fri, 24 Oct 2014 13:52:04 GMT

Best is a single table, but most aim for a star structure.

Often the model becomes a snowflake, if it's more like a a blizzard, you may have issues and need to review it :-).

That said the number of rows and data variability is also a factor.

As the data volumes get bigger, you should aim towards a simpler model.

Re: Qlikview Data Table Structure

Colin-Albert — Fri, 24 Oct 2014 13:57:10 GMT

Try this post by Steve Dark

http://community.qlik.com/thread/40146