Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Scatter Chart

I have 3 regions and related data in the attached QVW.In 1 exp I have Cost/Rsf and in other I have Cost/Csf...but since one of the expressions on NOAM and LATAM has 0 I only see ASIA.Where as I want to show 0 as well.

Ex: I want NOAM TO show Cost/Csf : 0 and Cost/HC = $40 ?

How can I do that ?

1 Solution

Accepted Solutions
clondono
Creator III
Creator III

How about for your two expressions:

Cost/RSF

=If (CSF=0, 0,SUM(Cost)/SUM(CSF))

Cost/FTE

=If (HC =0, 0,sum(Cost)/sum(HC))

1.png

Regards,

Carlos

View solution in original post

4 Replies
clondono
Creator III
Creator III

How about for your two expressions:

Cost/RSF

=If (CSF=0, 0,SUM(Cost)/SUM(CSF))

Cost/FTE

=If (HC =0, 0,sum(Cost)/sum(HC))

1.png

Regards,

Carlos

settu_periasamy
Master III
Master III

May be like attached?

Not applicable
Author

Ya...Thank you but what did you dIfferently... ?

settu_periasamy
Master III
Master III

I didn't do anything differently. When the value divided by 0, it gives Null value or Missing value (Means '-' hyphen)

so, just i used rangesum(field1/Field2) -> this gives 0 instead of Null.

Let's know, is this your need or something else?