topic Re: need help on alerts condition in QlikView

need help on alerts condition

vishalgoud — Mon, 06 Apr 2015 10:11:22 GMT

Hi Community,

I need a help on alerts condition..here is my problem.

i have three fields

1.ticket no(two types like "1234567" and "638738")

2.ticket actual effort hours

3.ticket approved hours.

now my requirement is to display alert where the ticket no starting with "12 "and if any ticket's effort hours are greater than of 85% of approved hours.

Thanks in Advance.

Re: need help on alerts condition

sunny_talwar — Mon, 06 Apr 2015 10:14:45 GMT

Is this alert going to be in a text box or straight table???

Best,

Sunny

Re: need help on alerts condition

vishalgoud — Mon, 06 Apr 2015 10:15:07 GMT

smal clarification condition is for any ticket starting with "12" and actual effort hours greater than 85% of approved hours

Re: need help on alerts condition

vishalgoud — Mon, 06 Apr 2015 10:15:41 GMT

i want a pop-up msg for the document

Re: need help on alerts condition

sunny_talwar — Mon, 06 Apr 2015 10:18:06 GMT

I am thinking you can color code it using nested if:

=If(ticket_no = '1234567', If(ticket_actual_hours * 0.85 > ticket_approved_hours, yourAlert, yourNoAlert))

this statement can be used to define colors also.

HTH

Best,

Sunny

Re: need help on alerts condition

avinashelite — Mon, 06 Apr 2015 10:18:30 GMT

to create alert you need to add one more column named as alert and try the expression like this.

if(wildmatch(ticket_no,'12*')>=1 and (sum(actual_efforts)/sum(approved_hours))>0.85, ticket_no)

Re: need help on alerts condition

vishalgoud — Mon, 06 Apr 2015 10:20:10 GMT

is this condition works in alert condition?

Re: need help on alerts condition

sunny_talwar — Mon, 06 Apr 2015 10:22:30 GMT

Can you share a sample application so that we can work on your exact output.

Best,

Sunny

Re: need help on alerts condition

avinashelite — Mon, 06 Apr 2015 10:23:08 GMT

try as below:

if(wildmatch(ticket_no,'12*')>=1 and (sum(actual_efforts)/sum(approved_hours))>0.85, ticket_no)

this should do

Re: need help on alerts condition

vishalgoud — Mon, 06 Apr 2015 10:25:48 GMT

Hi Avinash i need to write condition in alert condition

i.e in tools-->alerts

Re: need help on alerts condition

Anonymous — Mon, 06 Apr 2015 10:25:50 GMT

Take A chart object

and add ticket no as Dimension
and use below Expression

if(sum({<[ticket no]={'12*'}>}ticket actual effort hours)>(ticket approved hours*0.85),sum({<[ticket no]={'12*'}>}ticket actual effort hours))

Re: need help on alerts condition

sunny_talwar — Mon, 06 Apr 2015 10:29:27 GMT

Never used alerts before, so I unfortunately disregard my responses and I hope someone else will be able to help you.

Best,

Sunny

Re: need help on alerts condition

vishalgoud — Mon, 06 Apr 2015 10:35:43 GMT

Hi Bhagirath,

Thanks for the response,but i need to write the condition in alerts window for displaying a pop up message

Re: need help on alerts condition

jagan — Mon, 06 Apr 2015 10:39:51 GMT

Hi,

Try like this

LOAD

if(wildmatch(ticket_no,'12*') and actual_efforts/approved_hours >= 0.85, 1, 0) AS AlertFlag;

LOAD

ticket_no,

actual_efforts,

approved_hours

FROM DataSource;

Now in Tools -> Alerts -> Add -> Condition

=Sum(AlertFlag) > 0 and give your message

Hope this helps you.

Regards,

Jagan.

Re: need help on alerts condition

vishalgoud — Mon, 06 Apr 2015 11:13:22 GMT

Hi Jagan,

Thanks for ur reply.

Isn't it possible to write a condition directly in alert condition, because my script is bit confusing to write the statements those u mentioned.

Re: need help on alerts condition

pokassov — Mon, 06 Apr 2015 11:29:14 GMT

Hello!

Can you check?

Sergey

Re: need help on alerts condition

jagan — Tue, 07 Apr 2015 03:22:43 GMT

Hi,

Try this expression Alert

=Sum(Aggr(if(wildmatch(ticket_no,'12*') and actual_efforts/approved_hours >= 0.85, 1, 0), ticket_no)) > 0

Hope this helps you.

Regards,

Jagan.