Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jchang_snwl
New Contributor II

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
MVP
MVP

Re: set analysis on arithmetic operators

May be this:

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

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

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

1 Reply
MVP
MVP

Re: set analysis on arithmetic operators

May be this:

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

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

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