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

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
sunny_talwar

Can you try this:

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

Anil_Babu_Samineni

I don't know wny are you using$ here

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)