Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Creating data model and dashboards

Hi Team,

Data model : I have only single table based on that have to create data model, that data model should show star schema.

Dashboard : in my dashboard shows weekly bar chart initially later on it should show detail  bar chart like five days of in that particular week(this is the my dashboard)

please find the attached excel file for data.

Thanks in Advance,

Regards,

Munna

Thanks,
Srinivas
3 Replies
Highlighted

Re: Creating data model and dashboards

Write the load script this way

MainTable:

LOAD

     [employee ID],

     WeekDay([In Time]) as WeekDay,

     [In Time],

     [Out Time],

     Flag

FROM

DATA.xlsx

(ooxml, embedded labels, table is Sheet1);

And on the UI

Dimension :- WeekDay

Expression:- =Count( {<Flag={'Y'}>} [employee ID])


Highlighted
Creator
Creator

Re: Creating data model and dashboards

Hi Anand,

I need Data model like star schema and dashboard.

Regards,

Munna

Thanks,
Srinivas
Highlighted

Re: Creating data model and dashboards

Then try to create separate Date Dimension table which connect with Key called employee ID] & '-' & [In Time] and contains date dimension Intime, Outtime, WeekDay etc.

MainTable:

LOAD

    [employee ID] & '-' & Num([In Time]) as Key,

    [In Time] as InTime,

    [Out Time] as OutTime,

    Flag

FROM

DATA.xlsx

(ooxml, embedded labels, table is Sheet1);


DateDimTables:

Load

[employee ID] & '-' & Num([In Time]) as Key,

InTime as [In Time],

OutTime as [Out Time],

WeekDay(InTime) as WeekDay,

Year(InTime) as YearField,

Month(InTime) as MonthField

Resident MainTable;


Drop Fields InTime,OutTime;