Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Displaying certain values in a field in a line chart

Very new to QlikSense, never used QlikView, and haven't done any scripting before.

I have uploaded data with a field called "STATUS_Group" for work orders. Within that field, there are only three values, "Closed", "Open", and "Pre-Open." There is also a "DATE_REQUESTED" field which displays the values as "mm/dd/yyyy".

I'm trying to create a KPI object that just shows a total count of all "Open" and "Pre-Open" values for the current year.

I'm also trying to create a line chart where the Date is the bottom dimension, the count is the Y dimension, and there are two lines on the graph for "Closed" and "Open", with the "Open line representing all the "Pre-Open" and "Open" values.

Help?

1 Solution

Accepted Solutions
mattquinnterex
Contributor II

Re: Displaying certain values in a field in a line chart

Hi Casey,

Does your table have a unique ID field for the table? This would be the best to use for your measures. If not I'll use the fields you have stated.

In the data load editor you should do:

YEAR(DATE_REQUESTED) as YEAR_REQUESTED

KPI Object:

     COUNT({$<STATUS_Group={'Open','Pre-Open'},YEAR_REQUESTED={'=$(=YEAR(TODAY()))'}>}STATUS_Group)

Line Chart:

     Dimension: YEAR_REQUESTED

     Measure Opened: COUNT({$<STATUS_Group={'Open','Pre-Open'}>}STATUS_Group)

     Measure Closed: COUNT({$<STATUS_Group={'Closed'}>}STATUS_Group)

Hope this helps

4 Replies
mattquinnterex
Contributor II

Re: Displaying certain values in a field in a line chart

Hi Casey,

Does your table have a unique ID field for the table? This would be the best to use for your measures. If not I'll use the fields you have stated.

In the data load editor you should do:

YEAR(DATE_REQUESTED) as YEAR_REQUESTED

KPI Object:

     COUNT({$<STATUS_Group={'Open','Pre-Open'},YEAR_REQUESTED={'=$(=YEAR(TODAY()))'}>}STATUS_Group)

Line Chart:

     Dimension: YEAR_REQUESTED

     Measure Opened: COUNT({$<STATUS_Group={'Open','Pre-Open'}>}STATUS_Group)

     Measure Closed: COUNT({$<STATUS_Group={'Closed'}>}STATUS_Group)

Hope this helps

Not applicable

Re: Displaying certain values in a field in a line chart

That worked! Thank you very much!

Re: Displaying certain values in a field in a line chart

Seems, You got the answer. Can you close this thread by flag correct answer

mattquinnterex
Contributor II

Re: Displaying certain values in a field in a line chart

That's great glad to hear it.

Can you please mark my answer as the correct answer, thank you.