Load script - grouping / distinct

[qlikeers]

Hi!

I have a question because I can't find a solution; I have a fairly large source table that has a lot of similar records. When I try to do distinct or group, it doesn't work. Why?

I will add that I use "resident" when loading.

Example:
Columns: Day, Month, Qty, Value

Load
      month,
      sum(Value) as SumOfValue
Resident TBL
group by Month;

This doesn't work - the Month value should be unique in the result. But it is not. What could be the reason?

[hic]

It's case sensitive. "Month" is not the same as "month".

[qlikeers]

Hi @hic , thanks!

Of course, my mistake in the description.

Load
   Month,
   sum(Value) as SumOfValue
Resident TBL
group by Month;

[qlikeers · Accepted solution]

I think I know why, "Month" was created with the format() function. Converting to text solved the problem.