topic Changing Formats within Set Analysis in QlikView

Changing Formats within Set Analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Changing Formats within Set Analysis

sunny_talwar — Mon, 03 Oct 2016 17:47:33 GMT

Can you try this:

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

Re: Changing Formats within Set Analysis

Anil_Babu_Samineni — Mon, 03 Oct 2016 18:40:09 GMT

I don't know wny are you using$ here

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