topic Re: How do I script this? in QlikView

How do I script this?

Tue, 28 Mar 2017 18:48:12 GMT

I'm looking to create two expressions in a line chart:

If(severity = 'Critical' AND closed_date <> ' ')

If(severity = 'High' AND closed_date <> ' ')

if severity equals critical/high and the closed date is not empty

Thank you

Re: How do I script this?

sunny_talwar — Tue, 28 Mar 2017 18:51:25 GMT

Create a flag in the script for empty closed date

LOAD If(Len(Trim(closed_date)) = 0, 0, 1) as Flag_Closed_Date

Sum({<Flag_Closed_Date = {1}, severity = {'Critical'}>}Measure)

Sum({<Flag_Closed_Date = {1}, severity = {'High'}>}Measure)

UPDATE: Just realized with Nicole's response that you want to exclude null here... I have updated the above, but you can also use this (in addition to Nicole's provided option)

Sum({<closed_date= {"=Len(Trim(closed_date)) > 0"}, severity = {'Critical'}>}Measure)

Sum({<closed_date= {"=Len(Trim(closed_date)) > 0"}, severity = {'High'}>}Measure)

Re: How do I script this?

Nicole-Smith — Tue, 28 Mar 2017 18:55:16 GMT

Another option besides stalwar1's that will work as long as QlikView already knows that your closed_date is a date:

Sum({<severity = {'Critical'}, closed_date={'>0'}>}Measure)

Sum({<severity = {'High'}, closed_date={'>0'}>}Measure)

Re: How do I script this?

Wed, 29 Mar 2017 14:57:28 GMT

Hm, measure doesn't seem to be working for me.

Re: How do I script this?

vishsaggi — Wed, 29 Mar 2017 15:27:39 GMT

What they meant by Measure is that your Fieldname you use to sum. Like

Sum({< ..... >} YourFieldName).

Re: How do I script this?

Wed, 29 Mar 2017 15:35:18 GMT

This is what i'm getting when using MonthYear as my measure. High is showing, but critical is not, any ideas?

Re: How do I script this?

sunny_talwar — Wed, 29 Mar 2017 15:36:33 GMT

Convert this chart into a straight table and see if Critical shows up with any value or not

Re: How do I script this?

Wed, 29 Mar 2017 16:03:51 GMT

Straight table shows no values but a list box does. see pic

Re: How do I script this?

Wed, 29 Mar 2017 16:58:34 GMT

Sum({<closed_date= {"=Len(Trim(closed_date)) > 0"}, severity = {'Critical'}>}Measure)

changed sum to count and this worked, thank you!

Re: How do I script this?

sunny_talwar — Wed, 29 Mar 2017 17:01:17 GMT

Great