0 Replies Latest reply: Jan 30, 2017 6:12 PM by I-Cheng Ma RSS

    new to QlikSense and need the following help

    I-Cheng Ma

      Hi,

       

      New to QlikSense and need help to figure out the following requirements.

      Attached is my loading scrip to load the data

       

      1. incident count.

      Dimension:

      StartDate as Dimension

       

      Measures:

      Current Week: Count({<StartDate={“=InWeek(SartDate, Today(), 0)”}>}EventCode)

      Last Week: Count({<StartDate={“=InWeek(SartDate, Today(), -1)”}>}EventCode)

      Average Week last rolling 52 weeks: not sure the formula

      Last Year same week: Count({<Year={$(=vTodayYear-1)}, Week={$(=vTodayWeek)}>}EventCode)

      but not able to achieve the following graph.

       

      The x-axis simply display all available day in current week, last week, last year same week, etc.

      It's not same as the following requirement

      WeeklyIncCnt.png

      2. incident duration:

      Dimension: DayName

       

      4 measures: current week, last week, Average week last rolling 52 weeks(this one not working) and last year same week.

       

      I produce this:

      Duration_1.png

       

      I am able to produce 4 bars per weekday for management time and verification in separate chart.

      But the requirement need them to stack like the following. Any idea how to do this?

      Duration.png

       

      3. Incident Severity:

      Dimension:

      Severity level (that is major, medium, minor)

       

      4 measures: current day, same day last week, avg 52 week same day, same day last year

       

      I am able to create this

      severity_1.png

      But the requirement needs the following. Qlik Sense didn't allow multiple dimensions, how do I use current day, same day last week, etc? This is the similar issue in Incident count

      Severity.png

       

      Appreciate any help and advice.

       

      Regards

      I-Cheng