topic Re: Set Analysis Syntax When Extra Function is Included in QlikView

Set Analysis Syntax When Extra Function is Included

dukane24 — Thu, 21 Nov 2013 19:00:24 GMT

I was wondering if somebody could give me some advice on what I'm doing wrong here. This works fine until I include the piece where I'm trying to count items where the Est. Completion Date is 'less than' today. I've tried multiple variations (less than in place of equals, with and without $, etc.) and it seemed to work at one point but it was showing results where the Est. Completion Data was not being factored in at all. As-is below, my chart is just saying "No data to display". I have my date fields set in date format (M/D/YYYY) in the the load script.

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={$'<'(=Today(1))}>}[Defect ID])

I appreciate any advice you may have. Thanks!

Re: Set Analysis Syntax When Extra Function is Included

jerem1234 — Thu, 21 Nov 2013 19:19:08 GMT

Try this:

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={"<$(=Today())"}>}[Defect ID])

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={"<$(=Date(Today(),'M/D/YYYY'))"}>}[Defect ID])

Hope this helps!

Re: Set Analysis Syntax When Extra Function is Included

Anonymous — Thu, 21 Nov 2013 19:20:24 GMT

Try this:

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={"$(='<' & today())"}>}[Defect ID])

Re: Set Analysis Syntax When Extra Function is Included

MayilVahanan — Thu, 21 Nov 2013 19:23:14 GMT

Try like this

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={"<$(=Date(Today(1),'M/D/YYYY'))"}>}[Defect ID])

Hope it helps.

Note:

Please make sure both dates are in same format.

Re: Set Analysis Syntax When Extra Function is Included

dukane24 — Thu, 21 Nov 2013 20:02:22 GMT

Thank you!