Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
or
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?
I should prefer Horizontal but it is better to ask to the final user which format is better for his analysis
Hi,
Go through the QlikView Developer11 pdf once.
N see the Cross table concept
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.
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.