Empty field when loading

[Anonymous]

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]

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]

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])

  ;