# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

## reference to dimension itself in set analysis

hi!

i have FUNNEL2 dimension, which is dual:

Funnel2NUM(Funnel2)amount
go350

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

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

Funnel2amount_previous
go80

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!

14 Replies
Valued Contributor

## Re: reference to dimension itself in set analysis

Sort by Funnel2 and use expression as Above(Amount)

Contributor II

## Re: reference to dimension itself in set analysis

Yeah, it's true when I use a table. However, I need it as a standalone solutions, when there is no other cells to refer to.

MVP

## Re: reference to dimension itself in set analysis

Well you will have to reference some field right? For the first row you can have a check and pick a start value then on the following rows you can use Above()....

Contributor II

## Re: reference to dimension itself in set analysis

Try this

amount_previous = SUM (  {<Funnel2={< " \$( =above(Funnel2))" >} >}   amount)

Honored Contributor II

## Re: reference to dimension itself in set analysis

what is your UI expectation ?

Contributor II

## Re: reference to dimension itself in set analysis

no, it's not working - returns '-'

Contributor II

## Re: reference to dimension itself in set analysis

i need to count those, which were ready, steady, go, but not sold

count( {<

funnel2=

*P({<funnel2={<"funnel2-1">} >})

*E({<funnel2={<"funnel2">} >})

>}

distinct funnel2)

The question is what is should put instead of Bold text.

UI expectation:

funnel2count
go0
sold1
Contributor II

## Re: reference to dimension itself in set analysis

in Qlik you can't ignore the dimension from set analysis.

And May I know what is problem your facing in using above function?

Contributor II

## Re: reference to dimension itself in set analysis

this formula just does not work when put in set analysis (i tried it both inside and outside of function P).

if it worked, it would solve my task.

Note, my actual formula is more complicated (my original questions used simplified example)