Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Nagaraj6
Contributor II
Contributor II

How to include Null values

Hello Guys,

I need a help!

Nagaraj6_1-1689153147396.png

for  ex:01-04-2023 ,DOM Holiday FIT I want to include  Null count 56 to Direct ,Email+Ma,Orgnic,Refferal, 

I have formula & expected output: Direct count is 18 then   18+(18*56/454)=(18+2.2)=20.2=21,

                               Email+Ma count  is 8  then 8+(8*56/454)=(8+0.9)=8.9=9

How to apply this formula in script.for entire month I want  to apply.

 

 

 

Labels (2)
1 Reply
marcus_sommer
MVP
MVP