topic Re: New Table by Status type in QlikView

New Table by Status type

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: New Table by Status type

vishsaggi — Wed, 29 Mar 2017 14:39:44 GMT

May be this?

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

Re: New Table by Status type

Wed, 29 Mar 2017 14:50:31 GMT

Perfect, thanks!!