Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

new to QlikSense and need the following help

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

Community Browser