topic Re: Need help with below logic in QlikView

Need help with below logic

PrashantSangle — Wed, 07 Oct 2015 11:09:40 GMT

Dear All

I have attached my qvw file and xls file

also provide required logic inside it

Please help me to resolve it.

Let me know if you required any additional information.

It will be really helpful if got solution in script level.

Regards,

Re: Need help with below logic

avinashelite — Wed, 07 Oct 2015 11:16:34 GMT

Hi ,

One quick question for a single LINE_ID you have multiple Start_Date and End_Date so which date we need to use to compare with the start date

Re: Need help with below logic

PrashantSangle — Wed, 07 Oct 2015 11:32:31 GMT

Hi,

in 1st if start date is come in between start_date and End_date then pick that operand

else check start date is greater than or equal to start_Date and end_date is null then pick that operand

if both case fail then check start date is not equal to creation date

and then compare creation date with start_date and End_Date

I hope you got the logic.

Regards

Re: Need help with below logic

PrashantSangle — Wed, 07 Oct 2015 11:34:51 GMT

Re: Need help with below logic

cwolf — Wed, 07 Oct 2015 11:46:08 GMT

For your logic, the expression is correct.

These two lines will produce the result for ID 3386771

The expression some clearer:

=sum(IF([Start Date] >= Start_date AND ([Start Date] <= End_Date or ISNULL(End_Date)),OPERAND,

IF([Creation Date] <> [Start Date],IF([Creation Date] >= Start_date AND ([Creation Date] <= End_Date or ISNULL(End_Date)),OPERAND))

))

Re: Need help with below logic

Kushal_Chawda — Wed, 07 Oct 2015 12:02:06 GMT

Hi,

As per the data the logic which you are applying is satisfying two conditions

1) If [start date] in between start_date and End_date, Operand - 1635.33

2) if[creation date] in between start_date and End_date then Operand - 1692.48

So 1) +2) = 3327.81 what you are getting is correct for Line Id 3386771

Re: Need help with below logic

avinashelite — Wed, 07 Oct 2015 12:19:07 GMT

try this expression , I got the exact result

=sum(IF(([Start Date] >=Start_date) AND ([Start Date] <=End_Date),OPERAND,

IF(([Start Date] >= Start_date) AND len(trim(End_Date))=0,OPERAND,

IF([Creation Date] <> [Start Date],

IF(([Creation Date] >=Start_date) AND ([Creation Date] <End_Date),OPERAND,

IF(([Creation Date] >= Start_date) AND len(trim(End_Date))=0,OPERAND))))))

Re: Need help with below logic

avinashelite — Wed, 07 Oct 2015 12:21:59 GMT

Please find the attachment for the solution:

Re: Need help with below logic

PrashantSangle — Wed, 07 Oct 2015 15:24:36 GMT

Hi,

Initially I thought the same but my concern is

if my 1st if condition is true then why it is calculating value from else part.

I don't find it but I think I am missing something, but not able to find it.

I hope you got my point.

Thanks for the help.

Regards

Re: Need help with below logic

PrashantSangle — Wed, 07 Oct 2015 15:26:37 GMT

Hi,

Initially I thought the same but my concern is

if my 1st if condition is true then why it is calculating value from else part.

I don't find it but I think I am missing something, but not able to find it.

I hope you got my point.

Thanks for the help.

Regards

Re: Need help with below logic

PrashantSangle — Wed, 07 Oct 2015 15:29:36 GMT

Hi,

Thanks for help..

I will try it and get back to you as earlier as I can.

Regards

Re: Need help with below logic

PrashantSangle — Tue, 13 Oct 2015 05:46:17 GMT

Hi,

I used your solutions, It is working in test app.

Thanks again.

Regards

Re: Need help with below logic

avinashelite — Tue, 13 Oct 2015 06:01:46 GMT

Glad to help you ..