Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Loading problems on Qlikview

Hello,

I'm having a strange problem in load process.

I'm running an Informix stored procedure that creates a temporary table. I do a select to the temporary table to get all records, no filter, no calculations in this process.

The problem is that I have some columns from the record that should have value zero but Qlikview fills with values from another record!

If I run the process and select only the record that have zeros, in Qlikview appears with zeros If I select more than one record, zero values are substituted with other values.

Ex.

Running the query and getting all records columns volume, valgrosseur, valgrossmoe and prevdescfineur assume values diferente from zero.

mes product_id ship_mthd sales_type volume valgrosseur valbonuseur valgrossmoe prevdescfineur
4NUN08003031CUTOFF2ADD2,4952330,00000161,240002330,000000142,90000
4NUN08003033VENDA-23,96-20262,4100084,64000-15763,20000051,36000

Running the query with filter to get only the second row the columns have the right values on all columns.

mes product_id ship_mthd sales_type volume valgrosseur valbonuseur valgrossmoe prevdescfineur
4NUN08003033VENDA00,0000084,640000,0000000,00000

Thanks in advance for your help.

4 Replies

Re: Loading problems on Qlikview

Whatever you think Qlikview is doing, it will not create data that doesn't exist (unless instructed to do so). If Qlikview shows you data then you loaded that data from the source tables. Perhaps you can post a small Qlikview document that illustrates the problem.


talk is cheap, supply exceeds demand
jonas_rezende
Valued Contributor

Re: Loading problems on Qlikview

Hi, Ana Vieira.

See the script if there is any condition changing the value of these fields is less than zero consider zero. Ex.:

if(volume<0, 0, volume) as volume


​Hope this helps!

Not applicable

Re: Loading problems on Qlikview

Hi, there is no dta manipulation on the script.

The code is just this:

SQL EXECUTE PROCEDURE gps_salesstatistics_bi('2016-05-03','avieira');

Select * from tmp_sales_statistics where ano=2016;

jonas_rezende
Valued Contributor

Re: Loading problems on Qlikview

Hi, Ana Vieira.

Please, share the qvw us.

Regards,

Jonas Melo.

Community Browser