Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)