Chart Scripting? Help

Anonymous — Fri, 22 May 2015 01:05:16 GMT

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?

Re: Chart Scripting? Help

robert_mika — Fri, 22 May 2015 05:29:16 GMT

Could you add your data/app?

Re: Chart Scripting? Help

Anonymous — Tue, 26 May 2015 17:28:37 GMT

Here is my app and some example data

topic Chart Scripting? Help in QlikView

Chart Scripting? Help

Re: Chart Scripting? Help

Re: Chart Scripting? Help