topic Re: Set Analysis with null and or exceeded dates in QlikView

Set Analysis with null and or exceeded dates

Thu, 29 Oct 2015 16:15:54 GMT

Hey Guys need a little help ,

Count({$<State={'Committed','QC','Promote'},TargetDate2={"< Today()"}>

$<State={'Committed','QC','Promote'}, TargetDate2 ={'NULL'}>

}WorkID)

I need states that are Commited Qc and promote with either Target date is = 'NULL' or with a target date < Today

I am only getting nulls in but not exceed dates.

Thank You.

Re: Set Analysis with null and or exceeded dates

miguelbraga — Thu, 29 Oct 2015 16:36:14 GMT

Your set analysis expression is wrong as far I know it should be something like this:

=Count({$<State={'Committed','QC','Promote'},TargetDate2={$(=Today())}>WorkID) +

Count({$<State={'Committed','QC','Promote'},TargetDate2={$(=null())}>WorkID)

Hope it helps

Re: Set Analysis with null and or exceeded dates

Thu, 29 Oct 2015 16:47:55 GMT

Not working I need both Dates Less than Target date and 'NULL' In TargetDate2 I have a filter that outputs nulls as NULL. (for selection purposes . Thank You however

Re: Set Analysis with null and or exceeded dates

miguelbraga — Thu, 29 Oct 2015 16:58:20 GMT

UPDATED:

Try this change:

=Count({$<State={'Committed','QC','Promote'},TargetDate2={"<$(=vToday)"}>WorkID) +

Count({$<State={'Committed','QC','Promote'},TargetDate2={'NULL'}>WorkID)

And add a variable with the name:

vToday With the expression =Today()

Re: Set Analysis with null and or exceeded dates

tamilarasu — Thu, 29 Oct 2015 17:27:12 GMT

You can also try lik this...

=Count({$<State={'Committed','QC','Promote'},TargetDate2={"<$(=date(today(),'DD.MM.YYYY'))"}>WorkID) +

Count({$<State={'Committed','QC','Promote'},TargetDate2={'NULL'}>WorkID)

I assume that the date format for the field Target2 as 'DD.MM.YYYY'.. If not change it according to your data.

Re: Set Analysis with null and or exceeded dates

Thu, 29 Oct 2015 17:34:00 GMT

tried with variable also not working

Re: Set Analysis with null and or exceeded dates

Thu, 29 Oct 2015 17:34:51 GMT

tried not working thank you however

Re: Set Analysis with null and or exceeded dates

Thu, 29 Oct 2015 17:42:19 GMT

Thank You guys I got it trying this Thanks.

Count(

{

$<State={'Committed','QC','Promote'},TargetDate2={"<$(=Today())"}>

$<State={'Committed','QC','Promote'}, TargetDate2 ={'NULL',"< Today()"}>

}

WorkID)

Re: Set Analysis with null and or exceeded dates

varunreddy — Thu, 29 Oct 2015 17:49:55 GMT

Check the format of the date field. Date format you are using might be string