topic Re: Qlikview Data Structure in QlikView

Qlikview Data Structure

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

what is data structure in qlikview?

Re: Qlikview Data Structure

sarvesh — Wed, 15 Feb 2017 11:51:24 GMT

Hi..Prachi,

Data is loaded by LOAD or SELECT statements. Each of these statements generates an internal table. A table can always be seen as a list of something, each record (row) then being a new instance of the object type and each field (column) being a specific attribute or property of the object.

Rules

The following rules apply when loading data into QlikView:

QlikView does not make any difference between tables generated by a LOAD or a SELECT statement. This means that if several tables are loaded, it does not matter whether the tables are loaded by LOAD or SELECT statements or by a mix of the two.
The order of the fields in the statement or in the original table in the database is arbitrary to the QlikView logic.
Field names are used in the further process to identify fields and making associations. These are case sensitive, which often makes it necessary to rename fields in the script.

Regard's

Sarvesh Srivastava

Re: Qlikview Data Structure

buzzy996 — Wed, 15 Feb 2017 12:02:44 GMT

do u mean QlikView project data structure?

Re: Qlikview Data Structure

Anonymous — Wed, 15 Feb 2017 13:07:52 GMT

actually i am new to qlikview so i am not aware about it .if qlikview project data structure is different than other data structure then please explain it

Thank You

Best

Prachi

Re: Qlikview Data Structure

Anonymous — Wed, 15 Feb 2017 13:10:19 GMT

Thank you Sarvesh for the explanation.

Re: Qlikview Data Structure

buzzy996 — Wed, 15 Feb 2017 13:23:52 GMT

no..both are same,the point is here..in how many layers u r maintaining the data in ur project.

exp: level 1: data pull from ur source files to layer 1 qvw file (it's upto u or the difficulty of ur business--if u want to implement some data validation functions u can user here in script level to validate ur data) and save as .qvd

layer 2: data pull from .qvd to .qvw and create all u required chats-- called as presentation layer

note: most of the times its either 2-tire or 3-tire architecture developer will choose to maintain there data.

Re: Qlikview Data Structure

Anonymous — Wed, 15 Feb 2017 13:49:16 GMT

thanks shiva, can u please explain me architecture of qlikview in deatil.

Re: Qlikview Data Structure

buzzy996 — Wed, 15 Feb 2017 13:55:43 GMT

do u want "architecture of qlikview" or "architecture of qlikview project implementation"?

Re: Qlikview Data Structure

Anonymous — Wed, 15 Feb 2017 14:38:22 GMT

, first explain me architecture of qlikview.

Re: Qlikview Data Structure

buzzy996 — Wed, 15 Feb 2017 14:43:11 GMT

PFA,

Go with the attached PDF for more details

Re: Qlikview Data Structure

Anonymous — Wed, 15 Feb 2017 15:00:39 GMT

i didnt find any attached pdf.

Re: Qlikview Data Structure

buzzy996 — Wed, 15 Feb 2017 15:06:22 GMT

not sure,y u r not able to see the same.

any how,u can get the same form this link QlikView Server Architecture

Re: Qlikview Data Structure

Anonymous — Wed, 15 Feb 2017 15:17:59 GMT

yes now i got it.please also attached pdf of "architecture of qlikview project implementation".

Thank you

Best

Prachi

Re: Qlikview Data Structure

buzzy996 — Wed, 15 Feb 2017 15:20:24 GMT

tis is similar what i said on my second post.

there is no standard diagram for this.

Re: Qlikview Data Structure

Anonymous — Wed, 15 Feb 2017 15:23:45 GMT