topic Help in expression in QlikView

Help in expression

Wed, 05 Feb 2014 14:12:59 GMT

Hi,

Could anyone assist me in this please. As I have to show

Future Work Item WIP - essentially a report listing all work items by team which have not yet fallen due but are held in the database.

I did it with Bar chart. But I am not sure whether the way I did and whether the expression is right or not. please find attached.

Re: Help in expression

Gysbert_Wassenaar — Wed, 05 Feb 2014 14:24:43 GMT

Maybe this to count the cases with a due date that lies in the future:

COUNT({<DueDate={'>$(=today())'}>}DISTINCT(CaseID))

Re: Help in expression

Wed, 05 Feb 2014 15:32:16 GMT

Thanks and yes you are right. and will it means the cases which have not yet fallen due but are held in the database? is that you mean?

Re: Help in expression

Gysbert_Wassenaar — Wed, 05 Feb 2014 15:35:12 GMT

Yes, that's correct.

Re: Help in expression

Wed, 05 Feb 2014 15:36:53 GMT

Thanks very much!

Re: Help in expression

Tue, 18 Feb 2014 17:18:23 GMT

Can anyone help me as I have problem now. I tried in many ways but not able to find the solution.

I need to show as per below requirement.

Bar chart reflecting issues reaching their due date, to reflect the forthcoming week on the x-axis in the left-most column and the next four weeks across to the right.

Edit: as I already have the items per week. But now I need to show the future weeks data.

Please can anyone suggest me.

Re: Help in expression

Tue, 18 Feb 2014 17:33:20 GMT

Please can anyone help me as this is very very urgent

Re: Help in expression

Tue, 18 Feb 2014 18:07:38 GMT

Can anyone solve this please

Re: Re: Help in expression

Gysbert_Wassenaar — Tue, 18 Feb 2014 18:25:15 GMT

See attached qvw. If that is not what you need, please explain in more detail what the result should look like.

Re: Help in expression

Wed, 19 Feb 2014 11:11:19 GMT

Thanks. You craeted one chart item with

Dimesion1: =Weekname(DueDate)

Expression: count({<DueDate={'>=$(=date(today()))<=$(=date(today()+7*$(vWeeks)))'}>}DISTINCT CaseID)

The graph is showing 2014/08, 2014/09, 2014/10, 2014/16, 2014/17, 2014/18, 2014/20 on horizontal axes.

My user is asking to have only that month dates. i,e for march 2014 the weeks are 9,10,11,12. so, they are asking to have only that month weeks i,e 2014/09, 2014/10, 2014/11, 2014/12 . If it crossed match then it showuld show only april 2014 dates. Like this in the future also. But it shouldn't show more than four weeks dates and it shouldn't show completed weeks dates.

Is it possible?

Re: Help in expression

Wed, 19 Feb 2014 11:39:14 GMT

Any solution please?