topic Re: Data Modeling Question in QlikView

Data Modeling Question

israrkhan — Thu, 16 Jan 2014 13:59:10 GMT

Hi Community,

i have data modeling question, let say i have three tables

table1, table2, table3

table1 conected to table2 by DealerCode, and table2 conected to table3 by Targetdate.

so now if i add, any column from table1 as a dimension, and i do sum(value) on a column in table3, so will it work,

i mean will it group data on dimension.

and second thing is table viewer loads all the data, or only some data for view?

see the image please:

Thanks.

in the image created is date and has daily 1 value, and the target is monthly target which has monthly 1 value..

Re: Data Modeling Question

giakoum — Thu, 16 Jan 2014 14:04:30 GMT

Hi.

it should work, since this is stantard Qv behavior. Of course, if created is daily and targets are inserted monthly, then on every day you will see the monthly target sum.

Not sure if that is what you asked, please explain if not.

Preview only loads some of the data, not all.

Re: Data Modeling Question

Thu, 16 Jan 2014 14:07:49 GMT

Hi IsrarKhan,

Yes it is a standard behaviour. take care of the cardinality, as usual.

Preview is loading some lines only. if I remember well, it is 1,000 or 10,000 lines.

Fabrice

Re: Data Modeling Question

sundarakumar — Thu, 16 Jan 2014 14:12:04 GMT

Yes it will work fine and in preview you will be seeing only a preview of the first 1000 table rows will be shown

-Sundar

Re: Data Modeling Question

Peter_Cammaert — Thu, 16 Jan 2014 14:13:42 GMT

Preview shows first 1000 records according to Load order.

Peter

Re: Data Modeling Question

israrkhan — Thu, 16 Jan 2014 14:13:55 GMT

"Preview only load some data not all"...

so how to validate,that the figures are correct, if you are reading from a large text file..?

thanks for the reply...

Re: Data Modeling Question

Thu, 16 Jan 2014 14:15:06 GMT

A real table in the GUI

Fabrice

Re: Data Modeling Question

Thu, 16 Jan 2014 14:16:07 GMT

Also some function like NoOfRows('TableName') that return the number of lines for example

Fabrice

Re: Data Modeling Question

israrkhan — Thu, 16 Jan 2014 14:17:03 GMT

Thank you guys,

for your's helpful answers.

Re: Data Modeling Question

israrkhan — Thu, 16 Jan 2014 14:22:23 GMT

Hi Fabric,

Nice one answers.

last question is, if two date are in different format, one is DD/MM/YYYY and the other is MM/DD/YYYY

if i link them, will they work, or format should be same...

Kind Regards

Khan

Re: Data Modeling Question

salto — Thu, 16 Jan 2014 14:28:20 GMT

Hello IsrarKhan,

I try always to format the dates all the same, when it comes to compare them (it does not matter if they are DD/MM/YYY or any other format, as long as they all hold the same format).

Regards.

Re: Data Modeling Question

Thu, 16 Jan 2014 14:32:45 GMT

Not sure.

Normally yes because the dates are stored as numbers.

I will make a test by the end of the day (perhaps you will get the answer by then)

Fabrice

Re: Data Modeling Question

fernandotoledo — Thu, 16 Jan 2014 14:40:57 GMT

If they are stored as DATE after qlikview reads it, yes, they will link properly.

To assure they are stored as a DATE field, use the function Date#( DateField , 'date format') where the 'date format' should be the same as they appear in the original table.