topic Re: Logic Help in QlikView

Logic Help

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

HI Guys need some help in logic,

this is the logic below,

sum({<LinkDate,LinkDate={'>=$(vFROMDATE)'},LinkDate={'<=$(vToDate)'}, ISSUE_MOEVMENT_FLAG={1} >} ISSQTY)

in this i am getting few values 0,

with respect to key PLANT+MATRIAL, if ISSQTY >0 than it should not display in the report.

what whould be the logic pls suggest

Re: Logic Help

tresB — Wed, 30 Mar 2016 04:58:58 GMT

Your expression looks not right to me. There has to be some correction. Could you share a sample qvw explaining the required output?

Re: Logic Help

amayuresh — Wed, 30 Mar 2016 05:00:00 GMT

Try this,

=sum({1<LinkDate={">=$(=MonthStart(AddMonths(vFROMDATE)) <=$(=MonthEnd(vToDate))"}, ISSUE_MOEVMENT_FLAG={1} >} ISSQTY)

Re: Logic Help

amayuresh — Wed, 30 Mar 2016 05:02:08 GMT

Provide sample data

Re: Logic Help

jonathandienst — Wed, 30 Mar 2016 05:03:51 GMT

How are the two variables defined? Are they in the same format as LinkDate?

You can combine the LinkDate filter criteria into a single set criterion.

Re: Logic Help

Anonymous — Wed, 30 Mar 2016 05:07:32 GMT

Not Sure about your requirement ,you can try like this

sum({<LinkDate={'>=$(vFROMDATE)<=$(vToDate)'}, ISSUE_MOEVMENT_FLAG={'1'} >} ISSQTY).

Re: Logic Help

engishfaque — Wed, 30 Mar 2016 05:11:53 GMT

Dear Abhay,

Try this one,

=Sum ({<LinkDate={'>=$(vFROMDATE)<=$(vToDate)'}, ISSUE_MOEVMENT_FLAG={1}>} ISSQTY)

Kind regards,

Ishfaque Ahmed

Re: Logic Help

tyagishaila — Wed, 30 Mar 2016 05:23:57 GMT

Hi Abhay,

If you are not getting desired output by this

=Sum ({<LinkDate={'>=$(vFROMDATE)<=$(vToDate)'}, ISSUE_MOEVMENT_FLAG={1}>} ISSQTY)

than please share sample data. There may be another issue.

Cheers

Re: Logic Help

abhaysingh — Wed, 30 Mar 2016 05:34:52 GMT

Pls find the Sample Data

Date	Material	issueqty
01-01-15	M1	50
02-02-15	M2	10
02-01-15	M1	0
03-01-15	M4	0
05-02-15	M4	10

here i select date range 01-01-15 to 03-01-15 the output shud be


Date	Material	issueqty



03-01-15	M4	0

the logic is if KEY i.e Material is in the selected Date Range is =0 than it should show in the list only,

you can see Material M1 in two dates 01-01-15 and 02-01-15 the issue qty = 50 +0 , thats why it should not show.

Hope m clear

Re: Logic Help

tyagishaila — Wed, 30 Mar 2016 05:47:17 GMT

What do you mean by

ISSUE_MOEVMENT_FLAG={1}

Re: Logic Help

amayuresh — Wed, 30 Mar 2016 06:13:23 GMT

I think due to your condition it is not showing any value.

As per your requirement, I am using expression as

=if(sum({<MyDate={">=01-01-15 <=02-01-15"}>} issueqty)=0,1)

if we consider date range 01-01-15 and 02-01-15, then there is no material having sum of issueqty is 0.

So it is not showing any output.

if we consider date range 01-01-15 and 03-01-15, then there is material M4 having sum of issueqty is 0.

So it is showing in output.

Re: Logic Help

Wed, 30 Mar 2016 06:23:48 GMT

Hi Abhay,

One field should be referenced only once in set analysis. so ,

LinkDate={'>=$(vFROMDATE)'},LinkDate={'<=$(vToDate)'}, is not correct

instead it should be : LinkDate={">=$(vFROMDATE) <=$(vToDate)"}

Also, you should aggregate the sum of issueqty wrt Material.

You can try this:

=Aggr(<Your Expression> ,Material)

In this case,

=Aggr(Sum ({<LinkDate={'>=$(vFROMDATE)<=$(vToDate)'}, ISSUE_MOEVMENT_FLAG={1}>} ISSQTY),Material)

Re: Logic Help

abhaysingh — Wed, 30 Mar 2016 07:13:08 GMT

it is not giving me desired output, could you take the sample data and provide me the qvw pls

Re: Logic Help

tresB — Wed, 30 Mar 2016 09:21:13 GMT

May be like:

= Sum({<LinkDate={"=Sum({<LinkDate={'>=$(vFromDate)<=$(vToDate)'}>} issueqty)=0"},

Material=e({<LinkDate={"=Sum({<LinkDate={'>=$(vFromDate)<=$(vToDate)'}>}issueqty)>0"}>})>} issueqty)