Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Sort by Funnel2 and use expression as Above(Amount)
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.
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()....
Try this
amount_previous = SUM ( {<Funnel2={< " $( =above(Funnel2))" >} >} amount)
what is your UI expectation ?
no, it's not working - returns '-'
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:
funnel2 | count |
---|---|
ready | 0 |
steady | 0 |
go | 0 |
sold | 1 |
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?
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)