Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LOAD with Input Fields produces unexpected Results

For a new project I transformed 'regular' fields into input fields. Everything worked fine but then I wondered why I was getting unexpected results. I traced it down to a few records which were causing the incorrect numbers.

The two formulas below produce different results for some records in the script when QV_NET_REVENUE is loaded as an input field. When the script is run without input fields both formulas produce the same results.

QVRevenue * OptTx_Rev_Alloc as mytemp1,
QVRevenue * OptTx_Rev_Alloc as [QV_NET_REVENUE],

I'm using QV9 SR2... has anyone else come across this issue???

Thanks, Lukas

0 Replies