Line graph with multiple Dimension and Expression in Qliksense

Ask a Question

Hi,

i have a line chart where i am showing data weekly, Now i need it to display line chart, showing dimension with both weekly and Monthly as shown in below figure

In Load script

LOAD UserType,

Date(Date#(Date,'YYYYMMDD'),'MM-DD-YYYY') as DateLink,

Hits,

Bounced,

date(WeekStart(Date#(Date,'YYYYMMDD')), 'MM/DD/YYYY') &' - '& date(WeekEnd(Date#(Date,'YYYYMMDD')), 'MM/DD/YYYY') as Weekly_Dates,

week(Date#(Date,'YYYYMMDD')) as week_number;

SQL SELECT UserType,

Date,

Bounced,

Hits

FROM ViewTrafficTable;

In front end

Dimension: Weekly_Dates

Expression 1: Sum(Hits)

Expression 2: Sum(Bounced)

Please help on this.

0 Replies