reference to dimension itself in set analysis

[ziabobaz]

hi!

i have FUNNEL2 dimension, which is dual:

Funnel2	NUM(Funnel2)	amount
ready	1	100
steady	2	80
go	3	50

Is there way to write something like this is set analysis:

amount_previous = SUM (  {<Funnel2={< " $( =num(Funnel2)-1 ) " >} >}   amount).

Funnel2	amount_previous
ready	-
steady	100
go	80

alternatively, i can create Funnel2_previous dimension in the script. Can I use it like this?

amount_previous = SUM (  {<Funnel2={< " $( =text(Funnel2_previous))" >} >}   amount).

Thank you!

[agigliotti]

let's try replacing set analysis with if condition as below:

amount_previous = SUM(  if( Funnel2 = above(Funnel2), amount, 0 )

[ziabobaz]

it will never be true by definition

it does not work

[agigliotti]

what should means : status = {<"$(above(status))"} in your set analysis ?

[rangam_s]

you can use above (Complete expression) right for this scenario, either way you will get same output.

[balabhaskarqlik]

May be this:

For status:

Status = {"=$(=(Above(Status)))"}

Refer these:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/InterReco...

https://community.qlik.com/docs/DOC-8242