topic Re: Empty field when loading in QlikView

Empty field when loading

Anonymous — Wed, 02 Sep 2015 08:21:37 GMT

I am trying to load a table using the following code

test:

LOAD

[Libellé Site],

yearMap,

monthMap,

CATTCMap;

SQL SELECT [Libellé Site]

,year ([Datedesdivers]) as yearMap

,month ([Datedesdivers]) as monthMap

,sum(convert(float,[Vente TTC Globale])) as CATTCMap

FROM [dbo].[Divers] t

inner join dbo.Reseau ON t.[Code Site] = dbo.Reseau.[Code Site]

where month ([Datedesdivers]) =6

and year ([Datedesdivers])=2015

GROUP BY [Libellé Site],year ([Datedesdivers])

,month ([Datedesdivers])

;

When I try it on SQL Server there is values in the field CATTCMap but when loading in qlikview there is no data , how to correct the script ?

qlikviewwizard — Wed, 02 Sep 2015 08:28:47 GMT

Hi,

First load the table into QVDs with using joins,functions.

Later apply the join condtions and functions.

Hope this will work. Thank you.

maxgro — Wed, 02 Sep 2015 08:43:41 GMT

the result you get from this must be the same in sql server and qlikview

try to check another time and let we know

thanks

test:

SQL

SELECT [Libellé Site]

,year ([Datedesdivers]) as yearMap

,month ([Datedesdivers]) as monthMap

,sum([Vente TTC Globale]) as CATTCMap

FROM [dbo].[Divers] t

inner join dbo.Reseau ON t.[Code Site] = dbo.Reseau.[Code Site]

where month ([Datedesdivers]) =6

and year ([Datedesdivers])=2015

GROUP BY [Libellé Site],year ([Datedesdivers])

,month ([Datedesdivers])

;