Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ziabobaz
Contributor II

reference to dimension itself in set analysis

hi!

i have FUNNEL2 dimension, which is dual:

Funnel2NUM(Funnel2)amount
ready1100
steady280
go350

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

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

Funnel2amount_previous
ready-
steady100
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
passionate
Valued Contributor

Re: reference to dimension itself in set analysis

Sort by Funnel2 and use expression as Above(Amount)

ziabobaz
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
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()....

rangam_s
Contributor II

Re: reference to dimension itself in set analysis

Try this

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

agigliotti
Honored Contributor II

Re: reference to dimension itself in set analysis

what is your UI expectation ?

ziabobaz
Contributor II

Re: reference to dimension itself in set analysis

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

ziabobaz
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={"ready"}>})

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

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

>}

distinct funnel2)

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

UI expectation:

funnel2count
ready0
steady0
go0
sold1
rangam_s
Contributor II

Re: reference to dimension itself in set analysis

Sorry its my bad,.

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

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

ziabobaz
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)

Screenshot_18.jpg

Community Browser