Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator II
Creator II

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

View solution in original post

4 Replies
mattquinnterex
Creator II
Creator II

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

View solution in original post

Not applicable
Author

That worked! Thank you very much!

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
mattquinnterex
Creator II
Creator II

That's great glad to hear it.

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