topic I need help with a data model that allows drill down in QlikView

I need help with a data model that allows drill down

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I'm very new to using Qlikview. I'm still getting used to how a datamodel is used in Qlikview. I have a project I could use some advice on. I'm reviewing sales data and wold like to build a Qlikview that starts with sales data by year, then drills down to Month, Branch, sales date, and details on the sales date.

I'm not sure how to accomplish this in QlikView. I appreciate any advice that is offered.

Re: I need help with a data model that allows drill down

alexantone — Wed, 24 Dec 2014 00:08:53 GMT

Hello Bernard Smith

What is your database?

How much tables?

you must define for qlikview some table fact and some table dimensions in order to create the model

and for the differents load of the table you define the keys to link them

the reliationship betwwen tables (qvd files) is not the same than database (sql server , access)

in qlikview a link is create by same name

load table1

xyz as mykey,

afield ...

from myable1

load table2

abc as mykey...

bfield

from myable1

Re: I need help with a data model that allows drill down

robert_mika — Wed, 24 Dec 2014 06:16:50 GMT

Check this link

Creating Cycle and Drill Groups - YouTube

there is as well example in

Qlikview reference manual

http://community.qlik.com/servlet/JiveServlet/download/4549-1-69195/QlikView%20Reference%20Manual.pdf

Re: I need help with a data model that allows drill down

Tue, 30 Dec 2014 23:31:45 GMT

Robert and Alex,

Thank you for taking time to answer my question. Your guidance pointed me in the right direction. FYI, I changed my data model a bit to achieve the drill down effect I was looking for.