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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with expression

HI All,

I am trying to achive expression value but failing.... i am able to achive same result in excle but not in qlikview

Appreciate any help on this ... Please find attached Qvw and Source file

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Found Solution ...

Expression for Gn

=

sum

(

(B) * C

/

(1-(C))

)

Expression for Hn

= sum

(

(B) * C

/

(1-(C))

)

/

(

sum

(

(B)

/

(1-(C))

)

)

View solution in original post

3 Replies
NZFei
Partner - Specialist
Partner - Specialist

FYI

Not applicable
Author

You are loading G and H values from excel ....i am trying to achive those values in Qlikview

Not applicable
Author

Found Solution ...

Expression for Gn

=

sum

(

(B) * C

/

(1-(C))

)

Expression for Hn

= sum

(

(B) * C

/

(1-(C))

)

/

(

sum

(

(B)

/

(1-(C))

)

)