topic Re: Logic Modification: in QlikView

Logic Modification:

aveeeeeee7en — Thu, 10 Oct 2013 11:56:15 GMT

The Logic is Working fine but i need a little change.

I am Calculating Ageing : 'Customer Approved' - 'Pending for Customer Approval' WORKSTATUS

as Many Times they are coming i.e. first 'Pending for Customer Approval' than 'Customer Approved'

WORKSTATUS.

This is working fine where there is single status but working wrong when there comes multiple

'Pending for Customer Approval' and 'Customer Approved' WORKSTATUS.

For such cases i need difference MAXIMUM Customer Approved' WORKSTATUS

and MINIMUM 'Pending for Customer Approval' WORKSTATUS.

Do the Needful.

Thanks in Advance.

Re: Logic Modification:

Gysbert_Wassenaar — Thu, 10 Oct 2013 13:41:31 GMT

See attached example.

Re: Re: Logic Modification:

aveeeeeee7en — Sun, 13 Oct 2013 19:53:37 GMT

Sir I appreciate your work but when i applied your logic in my whole qvd it doesn't gave me the desired output.

I have also done Order By TICKETNUMBER but still no Result.

In some cases i am getting Desired Result and in Number of Cases i am not getting the result which i needed.

Re: Logic Modification:

aveeeeeee7en — Sun, 13 Oct 2013 20:10:44 GMT

Sample Cases Final Output Coming Wrong:

1. CD1300000301217

2. CD1300000303245

3. CD10000003067

4. CD110000095925

Re: Logic Modification:

aveeeeeee7en — Mon, 14 Oct 2013 11:33:19 GMT

Thank You G Wassenaar. You are Genius. Perfect Logic.

Re: Logic Modification:

aveeeeeee7en — Tue, 15 Oct 2013 05:45:14 GMT

The Logic you have shared is for single TICKETNUMBER.

I have to apply this logic for number of TICKETNUMBERS.

Kindly provide solution for that.

Re: Re: Logic Modification:

aveeeeeee7en — Tue, 15 Oct 2013 21:35:40 GMT

Sir

Your Logic is working Perfectly on the single Id

But when i am applying your logic on full data than it is not giving me appropriate result

even on Order by Ticketnumber.

Kindly Help.

Re: Re: Re: Logic Modification:

swuehl — Tue, 15 Oct 2013 22:05:00 GMT

You just need to check for a change in TICKETNUMBER.

Please check attached.

Re: Logic Modification:

aveeeeeee7en — Wed, 16 Oct 2013 04:45:51 GMT

Thank You very Much Swuehl. Awesome........!!

It works. You made my Day................!!