Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New Table by Status type

I've created a table chart to show me all cases closed in the current month, now I would like a separate table that shows me the same except the case status is either a new defect or an existing defect.

Here is what I am using for my current table value:

count({<CaseMonthYear={'$(vCurrMonth)'}>}distinct CLOSED_DTTM)

any guidance or suggestions greatly appreciated!

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

May be this?

count({<CaseMonthYear={'$(vCurrMonth)'}, CaseStatus = {'New Defect','Existing Defect'} >}distinct CLOSED_DTTM)

View solution in original post

2 Replies
vishsaggi
Champion III
Champion III

May be this?

count({<CaseMonthYear={'$(vCurrMonth)'}, CaseStatus = {'New Defect','Existing Defect'} >}distinct CLOSED_DTTM)

Not applicable
Author

Perfect, thanks!!