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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in DIV operation

Hi everybody,

I have i a single table an expression like this:  =$(vFinanceKey%) where

$(vFinanceKey%) = $(vFinanceKeyVirMain)/$(vFinanceGeneralKeyVir) and the two variables are different from zero.

The result I get is NULL.

Any idea?

Thanks in advance

2 Replies
Not applicable
Author

try to use div function.

div( $(vFinanceKeyVirMain),$(vFinanceGeneralKeyVir))

or try this

vFinanceKeyVirMain) / $(vFinanceGeneralKeyVir

Not applicable
Author

Thanks for your quick response.

I've tried the 1st case you say and I get ALWAYS 100%.

The 2nd, does nothing (field 'Key %')