Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
subash29
Contributor III
Contributor III
‎2015-04-21 03:36 AM

How to Create Dimension tables in qlikview

Hi,

I want to create a data model in Qlikview with  dimensional  tables but my database is completely with  Normalization tables (OLTP).Please help.

834 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2015-04-21 03:56 AM

Hi Raj,

  Can you explain little bit more about requirement.

-Jay

562 Views
0 Likes
jagan
Partner - Champion III
Partner - Champion III
‎2015-04-21 05:01 AM

Hi,

In Qlikview we won't create Dimension tables, we  use the dimension and fact tables to create the Datamodel.  Can you elaborate with some sample data and your expected result.

Regards,

Jagan.

562 Views
subash29
Contributor III
Contributor III
‎2015-04-21 05:19 AM
Author

In response to jagan

i have the database with normalized data model.i want to utilize the

database in Qlikview tool it has lots of foreign key relationship.I don't

know how to created the Perfect data model in Qlikview?I tried with joins

but not getting the correct result

On Tue, Apr 21, 2015 at 2:32 PM, jagan mohan <qcwebmaster@qlikview.com>

562 Views
0 Likes