If next row is 'Production' then...

[#1]

I want to calculate Amount (Qty x Unit Rate).

But the Condition is 'if the next row contains the words 'Production' then it should be 0, else it should be Qty x unit rate.

[richard_chilvers]

Hi

I have never used the BELOW function, although I did eventually get ABOVE working. I suppose its unreasonable to expect a calculation to work based on a row it hasn't reached yet in the table

I think perhaps the next step is to see whether you can prepare your data in the script, ready for this chart, as someone else hinted ?

[jagan]

Hi,

Try like this

if(wildmatch(Above([Description]),'Production'),0,Sum(Qty x [unit rate.]))

hope this helps you.

Regards,

Jagan.

[#4]

Dear Jagan,

Have uploaded Qlikview file and the base file.

i tried your command,

Still not working,.

pls try from your end.

[jagan]

Hi,

Try this expression

(if(wildmatch(below([Description]),'Production' ),0,sum((Quantity*[Unit Cost (Expected)]))))

If not working then let me know your expected output.

Regards,

Jagan.