topic Re: Expression Help in QlikView

Expression Help

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

Hi,

I need help with my Expression I am creating in a straight Table.

I need it to do.... if 'Matching_Indicator contains '-1-' then minus dates between the Delivery2 and the End Date of the line above, if it is more or equal to 1 say 'CHECK'

This is what I have in there at the moment but is not working I have tried serval different ways but nothing works. 😞

IF(Matching_Indicator='-1',Sum(Delivery2-Above('End Date') >=1,'CHECK'

Re: Expression Help

sunny_talwar — Fri, 28 Aug 2020 13:55:05 GMT

Not entirely sure based on the information provided, but may be this

IF(Matching_Indicator = -1, If(Delivery2 - Above([End Date]) >= 1, 'CHECK') )

Re: Expression Help

PrashantSangle — Fri, 28 Aug 2020 15:44:51 GMT

try below

IF(Matching_Indicator='-1' and Interval(Delivery2 - Above('End Date')) >=1,'CHECK')

IF(Matching_Indicator='-1' and Delivery2 - Above('End Date') >=1,'CHECK')

Regards,

Re: Expression Help

Brett_Bleess — Wed, 09 Sep 2020 15:04:23 GMT

You have received two responses, we would appreciate it if you would return to the thread and close it out by choosing the post that worked, as they are a bit different. You can use the Accept as Solution button on the post that worked for you. If you did something different, you can post what you did, then use the button to mark that, but if one of the other posts did help, I would recommend using the 'like' option to give the poster some credit that way.

Regards,
Brett

Re: Expression Help

Rosiered — Wed, 09 Sep 2020 15:11:07 GMT

Sorry neither of the options worked 😞 I have put it to one side for now as I have had to pick up some other work. I will return to looking in to it toward the end of the month. Thank you both for your help it is really appreciated