topic Re: How to add IF null statement to current expression in QlikView

How to add IF null statement to current expression

Thu, 06 Apr 2017 16:27:38 GMT

I am currently counting First discovered dates, how would i add

"count first discovered within the last month IF Closed_mitigated_On is null'

Open:

Count({$<First_Discovered={'>=$(=MonthStart(Today()))<=$(=Today())'}> } First_Discovered)

Also, I am looking to add a compliance flag into this this chart. How would I write Count(compliance_flag for the last month)

the above count statement isn't working.

Re: How to add IF null statement to current expression

Gysbert_Wassenaar — Thu, 06 Apr 2017 16:42:10 GMT

Not sure what you want. Perhaps this:

Count({$<First_Discovered={'>=$(=MonthStart(Today()))<=$(=Today())'}, Closed_mitigated_On-={'*'} >} First_Discovered)

Re: How to add IF null statement to current expression

Anil_Babu_Samineni — Thu, 06 Apr 2017 16:44:45 GMT

"count first discovered within the last month IF Closed_mitigated_On is null'

For this, You can use like below

If(IsNull(Closed_mitigated_On), Count({<Month = {'$(=Max(Month, -1))'}>}[first discovered]))

If(IsNull(Closed_mitigated_On), Count({<Month = {'$(=AddMonths(Max(Month),-1))'}>}[first discovered]))

Also, I am looking to add a compliance flag into this this chart. How would I write Count(compliance_flag for the last month)

the above count statement isn't working.

For this, you can write like below

Count({<Month = {'$(=Max(Month, -1))'}>}compliance_flag)

Count({<Month = {'$(=AddMonths(Max(Month),-1))'}>}compliance_flag)

Re: How to add IF null statement to current expression

Thu, 06 Apr 2017 17:18:58 GMT

None of these worked

Re: How to add IF null statement to current expression

Anil_Babu_Samineni — Thu, 06 Apr 2017 17:22:16 GMT

Would you explain more please

Re: How to add IF null statement to current expression

Thu, 06 Apr 2017 17:28:55 GMT

the 'month' isn't working and it isn't returning any data.

Count({<Month = {'$(=AddMonths(Max(Month),-1))'}>}compliance_flag

How to add IF null statement to current expression

Re: How to add IF null statement to current expression

Anil_Babu_Samineni — Thu, 06 Apr 2017 17:30:28 GMT

May be you don;t have month field. Use same month field if you have and then count of that

Re: How to add IF null statement to current expression

Thu, 06 Apr 2017 17:33:58 GMT

it still says "expression Ok" but doesn't return any values.

the compliance flag has "compliant" and "non compliant'. so the current expressions for my chart are "Open", "closed" and I want two more that are "compliant" and "non Compliant" that show data from the last month.

Re: How to add IF null statement to current expression

Anil_Babu_Samineni — Thu, 06 Apr 2017 17:36:15 GMT

Is there any chance to share application?

Re: How to add IF null statement to current expression

vinieme12 — Thu, 06 Apr 2017 17:54:11 GMT

Try

Count({$<First_Discovered={'>=$(=MonthStart(Today()))<=$(=Today())'}, Closed_mitigated_On ={"=len(Closed_mitigated_On )=0"} >} First_Discovered)

Re: How to add IF null statement to current expression

Thu, 06 Apr 2017 18:18:52 GMT

No difference

Re: How to add IF null statement to current expression

vinieme12 — Thu, 06 Apr 2017 18:24:32 GMT

what is the format of this field: First_Discovered

Re: How to add IF null statement to current expression

Thu, 06 Apr 2017 18:29:17 GMT

MM/DD/YYYY

Re: How to add IF null statement to current expression

vinieme12 — Thu, 06 Apr 2017 18:43:13 GMT

Try, for previous Month data

=Count({$<First_Discovered={">=$(=DATE(Addmonths(Today(),-1),'MM/DD/YYYY'))<$(=DATE(MonthStart(Today()),'MM/DD/YYYY'))"}> } First_Discovered)