topic Problem in DIV operation in QlikView

Problem in DIV operation

Fri, 02 Aug 2013 12:11:08 GMT

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

Fri, 02 Aug 2013 12:17:19 GMT

try to use div function.

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

or try this

vFinanceKeyVirMain) / $(vFinanceGeneralKeyVir

Fri, 02 Aug 2013 12:21:28 GMT

Thanks for your quick response.

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

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