Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikmeplease
Contributor III

Changing Formats within Set Analysis

Hi Everyone,

I have the following formula :

Sum (NISTA) / Sum(Num(TaskTime)*1440) * 60)

However, I Created a flag in my script to identify where exactly I need this to take place.

Thus I Believe set analysis would be the answer for this, but the problem comes in with the format conversion (NUM) and the additional calculations (*1440*60).

Is there a way to do this in a Set analysis?

the following doesn't work but explains what i need to do:

IF(FLAG=1,Sum (NISTA) / Sum(Num(TaskTime)*1440) * 60))


SET ANALYSIS FORM:


Sum({$<FLAG={$(=1)}>}NISTA) / (Sum({$<FLAG={$(=1)}>}NUM(TASKTIME)*1440)*60

Please can anyone assist.

Thanks in advance.

2 Replies

Re: Changing Formats within Set Analysis

Can you try this:

Sum({<FLAG = {1}>} NISTA) / Sum({<FLAG = {1}>} Num(TaskTime)*1440) * 60)

Re: Changing Formats within Set Analysis

I don't know wny are you using$ here

Sum({$<FLAG={1}>}NISTA) / (Sum({$<FLAG={1}>}NUM(TASKTIME)*1440)*60

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)