Optimise Code

Surya — Sat, 16 Nov 2024 01:41:53 GMT

Dear All,

if(RecNo = 1 or PEEK(MATERIAL) = MATERIAL,0,
IF(FREQUENCY_DAYS_MAC = 1,SUM_PROD_QTY_DAILY_MAC,

IF(FREQUENCY_DAYS_MAC = ,SUM_PROD_QTY_DAILY_MAC + PEEK(SUM_PROD_QTY_DAILY_MAC),

IF(FREQUENCY_DAYS_MAC = 3,SUM_PROD_QTY_DAILY_MAC + PEEK(SUM_PROD_QTY_DAILY_MAC)+Peek(PEEK(SUM_PROD_QTY_DAILY_MAC)),

IF(FREQUENCY_DAYS_MAC = 4,SUM_PROD_QTY_DAILY_MAC + PEEK(SUM_PROD_QTY_DAILY_MAC) + Peek(PEEK(SUM_PROD_QTY_DAILY_MAC)) + PEEK(Peek(PEEK(SUM_PROD_QTY_DAILY_MAC))),

IF(FREQUENCY_DAYS_MAC = 5,SUM_PROD_QTY_DAILY_MAC + PEEK(SUM_PROD_QTY_DAILY_MAC) + Peek(PEEK(SUM_PROD_QTY_DAILY_MAC)) + PEEK(Peek(PEEK(SUM_PROD_QTY_DAILY_MAC))) + PEEK(PEEK(Peek(PEEK(SUM_PROD_QTY_DAILY_MAC))))

Like we need to implement 90 days..Please suggest easiest way to achieve this.

Re: Optimise Code

Anil_Babu_Samineni — Mon, 16 Dec 2019 11:47:00 GMT

I would go with Flags for number of arbitrary ranges on each section.

Re: Optimise Code

Surya — Tue, 17 Dec 2019 04:59:19 GMT

Please give some example..it will help to me.

Re: Optimise Code

Anil_Babu_Samineni — Tue, 17 Dec 2019 12:58:29 GMT

Please explain the business logic?

topic Optimise Code in QlikView

Optimise Code

Re: Optimise Code

Re: Optimise Code

Re: Optimise Code