topic Re: How to write expression? in QlikView

How to write expression?

Mon, 03 Feb 2014 11:21:10 GMT

Hi,

I have to create a straight table to show

Work Item Due Status (open, closed, in progress) - by team and to include aged analysis, last note and date of last note but only in respect of work items that have fallen due or are overdue.

Please could anyone help me with expression please of how to get above result. I tried but it seems the result is not ok.

Thanks.

Re: How to write expression?

juleshartley — Mon, 03 Feb 2014 11:28:14 GMT

Do you mean that the table only displays rows where work items are overdue? Or just certain fields are visible based on this?

Re: How to write expression?

Mon, 03 Feb 2014 11:42:35 GMT

I mean the entire straight table is wrong. because it is not showing values accurate. Please help me how to set this.

Re: How to write expression?

juleshartley — Mon, 03 Feb 2014 11:46:45 GMT

But can you explain what you want the table to show? Do you just want to show rows where the work item is over due or do you want to show all of the rows, but only certain COLUMNS if it is overdue?

Re: How to write expression?

Mon, 03 Feb 2014 11:55:59 GMT

I would need to show the workitems like below

e.g.
Team                Open           Closed            Total
Review
Variations
IVASTRT
..
..
Total

Then look to introduce the Due Date and a summary of how many issues are within the due date and the number of breaches for each team. One for open issues and one for closed.

Team          Open   WithinDueDate         BreachedDueDate      OpenTotal
Review
Variations
IVASTRT
..
..
Total

Closed WithinDueDate          BreachedDueDate         ClosedTotal
Review
Variations
IVASTRT
..
..
Total

Re: How to write expression?

Mon, 03 Feb 2014 12:19:25 GMT

Any help please.

Re: Re: How to write expression?

juleshartley — Mon, 03 Feb 2014 12:20:09 GMT

This, for example, would give you a count of overdue issues across the 'TeamToAddress' dimension:

Sum(

Aggr(

(Count(DISTINCT

if(Date(DueDate)>Today(), IssueId)

)

, TeamToAddress

)

Re: How to write expression?

Mon, 03 Feb 2014 12:27:53 GMT

thanks and how can I show how many items open closed and inprogress?

Re: How to write expression?

juleshartley — Mon, 03 Feb 2014 13:09:01 GMT

That depends on the criteria... but I assume that open, for example, does not have a 'DateIssueResolved', so you would use something like:

Sum(

Aggr(

Count (Distinct

If(isnull(DateIssueResolved), IssueID)

)

,TeamToAddress)

I'm afraid I can't write them all out for you