Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted
Specialist
Specialist

Re: reference to dimension itself in set analysis

Sort by Funnel2 and use expression as Above(Amount)

Highlighted
Creator III
Creator III

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.

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

Highlighted
Creator II
Creator II

Re: reference to dimension itself in set analysis

Try this

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

Highlighted
Partner
Partner

Re: reference to dimension itself in set analysis

what is your UI expectation ?

Highlighted
Creator III
Creator III

Re: reference to dimension itself in set analysis

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

Highlighted
Creator III
Creator III

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
Highlighted
Creator II
Creator 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?

Highlighted
Creator III
Creator III

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