Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ziabobaz
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
passionate
Specialist
Specialist

Sort by Funnel2 and use expression as Above(Amount)

ziabobaz
Creator III
Creator III
Author

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.

petter
Partner - Champion III
Partner - Champion III

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

Try this

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

agigliotti
Partner - Champion
Partner - Champion

what is your UI expectation ?

ziabobaz
Creator III
Creator III
Author

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

ziabobaz
Creator III
Creator III
Author

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

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
Creator III
Creator III
Author

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