Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

smaranda_fetila
New Contributor II

Chart Scripting? Help

These are my three tables:

Transaction:

LOAD locationid,

    trans_act,

    Hour,

    Soldon,

    Location

FROM

(qvd);

Transaction_detail:

LOAD trans_act,

    eventid,

    itemid,

    Event,

    lastYearEventId,

FROM

(qvd);

MasterCalendar:

LOAD TempDate as Soldon,

    Week(TempDate) as Week,

    Year(TempDate) as Year,

    Month(TempDate) as Month,

    Day(TempDate) as Day,

    Weekday(TempDate) as WeekDay

Resident TempCal

Order by TempDate ASC;

I want to create a chart that will reflect an hourly count of items sold in a particular WeekDay, for an Event and compare it, in the same chart, to an hourly count of items sold on the same WeekDay (that will be a different date), for the lastYearEventId.

I had it working without comparing it:

  • dimension: Hour
  • expression: count(itemid)

How should I approach the camparison to lastYearEventId?

2 Replies

Re: Chart Scripting? Help

Could you add your data/app?

smaranda_fetila
New Contributor II

Re: Chart Scripting? Help

Here is my app and some example data