topic Re: Need Help........... in QlikView

Need Help...........

paulwalker — Wed, 18 Dec 2013 13:20:07 GMT

Hi Community,

I have OrderQty and Schedule Qty..

OrderQty should be less than ScheduleQty....

then i want to show alert..

please anyone can help me......

Thanks in Advance..........

Re: Need Help...........

Anonymous — Wed, 18 Dec 2013 13:44:32 GMT

1. DECLARE TWO VARIABLE GLOBALLY (SETTING ->DOCUMENT PROPERTIES->VARAIBLE)

VARIABLE1 = SUM(Order Qty)

VARIABLE2 =SUM(Sch Qty)

2. NOW GO TO TOOLS -> ALERTS

3. CLICK ADD BUTTON

4. IN CONDITION BOX TYPE =Variable1>Variable2

5 type OrderQty is greator in message box !!.

6. press OK.

when you reload alert box will come.

note in your excel data the order quantity is less then sch quantity so alert will not come for year 2013 and month 12

untill if you really want to see alert box the either change and add value or let it automatically happen.

regards,

anant

Re: Need Help...........

ljackson — Wed, 18 Dec 2013 13:45:55 GMT

Is this what you mean?

Re: Need Help...........

ljackson — Wed, 18 Dec 2013 13:47:48 GMT

I created a chart, then included an 'if' expression to see if the order qty was less than the scheduled order. It creates a new column, but will only show an 'alert' on the relevant line.

Re: Need Help...........

Peter_Cammaert — Wed, 18 Dec 2013 13:54:32 GMT

Or this one. Check background color expression of Sch Qty column. No extra columns needed.

Luck,

Peter

Re: Need Help...........

ljackson — Wed, 18 Dec 2013 13:57:30 GMT

Ahh yes, I prefer your reply to mine!

Re: Need Help...........

stevedark — Mon, 30 Dec 2013 08:31:29 GMT

Hi Paul,

This seems to be the same question you asked in another thread?

If both fields exist on one row of the source data the best bet is to add a new calculated field in the load script:

UnitPrice,

Cost,

If(UnitPrice > Cost, 1, 0) as AlertCount,

If(UnitPrice > Cost, 'Yes', 'No') as Alert,

You can then have a text box with the following expression to show the number of Alerts:

=sum(AlertCount)

You could then have an Action on here to select Yes in the Alert field. You could also show Alert as a simple Yes/No List Box.

How that helps,

Steve