Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator II

Line graph with multiple Dimension and Expression in Qliksense

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

LineChart.PNG

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