topic data on the previous lines in QlikView

data on the previous lines

Sat, 25 Apr 2015 06:06:02 GMT

Hi,

How to implement this formula in QlikView?

thank you

robert_mika — Sat, 25 Apr 2015 06:57:13 GMT

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

Could you describe your requirements or post screenshot?

Sat, 25 Apr 2015 07:23:51 GMT

thanks for the response

screenshot

Can I get this formula in QV?

test = 11 in cell

Sat, 25 Apr 2015 08:57:14 GMT

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

Sat, 25 Apr 2015 09:10:52 GMT

thank you 😃

Sat, 25 Apr 2015 11:18:22 GMT

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

if were I to refer to previous calculations?

this is possible in Qv?

Sat, 25 Apr 2015 12:25:01 GMT

here are a couple of examples

Thu, 30 Apr 2015 09:28:54 GMT

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