topic Re: Data modeling (vertical vs horizontal) in QlikView

Data modeling (vertical vs horizontal)

maleksafa — Mon, 07 Jul 2014 09:40:46 GMT

Hi,

i am currently starting a new project and i was looking first at my data sources and i need to choose the appropriate data model for my dashboard.

my current situation is that i will end up having a schema that is big vertically or Horizontally (in number of expressions), for example i might have

Country	Store	Transfer In	Transfer Out	Amount In	Amount Out
Leb	A	10	-10	1500	-1500

Country	Store	Movement	Flag
Leb	A	10	TransferIn
Leb	A	-10	TransferOut
Leb	A	1500	AmountIn
Leb	A	-1500	AmountOut

to note that my data model will consist of around 70 Million records if i go with the Horizontal schema, and i have around 20 expressions, so the number will be huge if i will go vertically with less columns.

what do you think is the best approach?

Re: Data modeling (vertical vs horizontal)

alexandros17 — Mon, 07 Jul 2014 09:43:59 GMT

I should prefer Horizontal but it is better to ask to the final user which format is better for his analysis

Re: Data modeling (vertical vs horizontal)

mahesh_agrawal — Mon, 07 Jul 2014 09:45:47 GMT

Hi,

Go through the QlikView Developer11 pdf once.

N see the Cross table concept

Re: Data modeling (vertical vs horizontal)

maleksafa — Mon, 07 Jul 2014 09:51:39 GMT

i know the cross table and if i will go horizontally i will have to use it, but the question is to go horizontally or not, considering the huge number of records that i will end up having.

Re: Data modeling (vertical vs horizontal)

maleksafa — Mon, 07 Jul 2014 09:52:33 GMT

for the user format it will be the same whether it is horizontal or vertical. the method of calculation will be different but the result will be the same.