topic Re: How to Achieve this logic in QlikView

How to Achieve this logic

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

Hi All,

If there are 5 Weeks in the last month of the Quarter, consider 3 Weeks Quantity as “In Transport” and if there are 4 Weeks, consider 2 Weeks Quantity as “In Transport”

How to Achieve this logic and i don't have sample data.

Re: How to Achieve this logic

MarcoWedel — Tue, 12 Jun 2018 20:08:42 GMT

Can you create a short table consisting of some input values and a description of your required result?

Re: How to Achieve this logic

pooja_prabhu_n — Wed, 13 Jun 2018 05:29:16 GMT

Hi Prasanth,

You can calculate the week number using the below formula:

'Week'&Ceil(Day(Date)/7) as Week

Then use the below logic to consider the 3 weeks or 2 weeks quantity.

Aggr( Round(Max(Ceil(Day(Date)/7))/2),MONTH)

I have attached sample qvw file for your reference.

Re: How to Achieve this logic

Anonymous — Wed, 13 Jun 2018 05:49:43 GMT

Thank you Nagaraj....