data on the previous lines

[#1]

Hi,

How to implement this formula in QlikView?

thank you

[robert_mika]

During weekend most of the user are using PE edition like myself.

Could you describe your requirements or post screenshot?

[#3]

thanks for the response

screenshot

Can I get this formula in QV?

test = 11 in cell

"

SUMIFS

"

!

[#4 · Accepted solution]

Hello,

I amusing PE, but I understood from the excel formula, is that you need to show the value for duplicate row and 0 otherwise.

You can try below in you straight table expression:

if(Count = aggr(above(Count,0),shipment), 0, Count)

If anything else then please share with us as suggested by Robert_Mika‌

Thanks,

Singh

[#5]

thank you 😃

[#6]

if(Count = aggr(above(Count,0),shipment), 0, Count)

if were I to refer to previous calculations?

this is possible in Qv?

[#7]

here are a couple of examples

[#8]

You cannot refer cells in the expression in qlikview. But you can do is play around with Above and Below functions in qlikview.

If you need to further use the calculation expression in other then you can use it directly by the Name of the calculated expression.

ex:

Sum of Sales = expr1:  sum(Sales)

Reduce Sales = expr2: [Sum of Sales]-1000

Hope this was helpful.

Thanks,

Singh