topic Re: Set Analysis Expression isn't Working in App Development

Set Analysis Expression isn't Working

Anonymous — Fri, 11 May 2018 18:47:59 GMT

Hi - I've been trying to get the set analysis in this expression to work but I haven't been successful. I think it might be a syntax error but I can't find where it is. Can anyone help? I know that is calculating the correct number for the portion of the expression that calculates the number of days ((MonthEnd(max(DeliveryDate))-(today()-2))). I tested that separately but when I add it to the set analysis it doesn't work.

sum({$<OrderToDeliveryDays={'>=($=(MonthEnd(max(DeliveryDate))-(today()-2)))'}>}Sales)

Essentially, this expression is only summing the sales when the # of OrderToDeliveryDays is greater than or equal to a specified number.

Thanks.

Re: Set Analysis Expression isn't Working

sunny_talwar — Fri, 11 May 2018 19:33:44 GMT

Try this

Sum({$<OrderToDeliveryDays = {">=$(=Floor(MonthEnd(Max(DeliveryDate)))-(Today()-2))"}>} Sales)

Re: Set Analysis Expression isn't Working

rafatashiro — Fri, 11 May 2018 19:35:28 GMT

Hello!

Did U try to use double quotes?

sum({$<OrderToDeliveryDays={ " >=($=(MonthEnd(max(DeliveryDate))-(today()-2))) " }>}Sales)

Re: Set Analysis Expression isn't Working

Anonymous — Sat, 12 May 2018 01:35:23 GMT

Thanks! The use of the floor function worked.

Re: Set Analysis Expression isn't Working

Anonymous — Sat, 12 May 2018 01:35:54 GMT

The floor function solved my issue. The use of single vs. double quotes didn't make a difference.

Re: Set Analysis Expression isn't Working

sunny_talwar — Sat, 12 May 2018 15:22:18 GMT

Although it might not have made a difference, I suggest to use double quotes for search string because the later versions of QlikView and Qlik Sense now don't treat both the same way. Read more on this here

Quotes in Set Analysis

Re: Set Analysis Expression isn't Working

Anonymous — Wed, 16 May 2018 16:48:45 GMT

Thank you Sunny! That was helpful.