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: 
Anonymous
Not applicable

set analysis on arithmetic operators

Hello,

I have table like this,

UIDprdtime
20.00167
30.00247
20.003214
70.00187
40.007314
10.004914
10.00157
20.006421
20.000928
30.008514
30.007121
30.002828
40.004621
70.005814
70.006921
10.008421

I want to have a chart which has [time] as dimension and three expressions

log(log(1/(1-prd)))

15+log(prd)

prd

There is a defined variable vUID and it will used for set analysis for expressions, such as:

log(log(1/(1-({<[UID]={$(vUID)}>}  prd))))

15+({<[UID]={$(vUID)}>}  prd)

({<[UID]={$(vUID)}>}  prd)

Just don't know what exact syntax to apply this kind of set analysis to those expressions.

Thanks,

Josh

1 Solution

Accepted Solutions
sunny_talwar

May be this:

log(log(1/(1-Only({<UID = {$(vUID)}>}prd))))

15+log(Only({<UID = {$(vUID)}>}prd))

Only({<UID = {$(vUID)}>}prd)

View solution in original post

1 Reply
sunny_talwar

May be this:

log(log(1/(1-Only({<UID = {$(vUID)}>}prd))))

15+log(Only({<UID = {$(vUID)}>}prd))

Only({<UID = {$(vUID)}>}prd)