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

Announcements
Join us in Bucharest on Sept 18th 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))

)

)