Trouble with a pivote table

[qlikconsultant]

I have three attributes:

orderyear,

ordermonth

and amount

I have created a pivote table:

I put orderyear and ordermonth in the dimension and the expression is sum(amount).

But i get object shows no data.

I checked the data with a table box.

So where is my mistake?

[ecolomer]

try with RangeSum(amount)

¿are you sure about the data?

[GabrielAraya]

Try with a table object and your tree fields .. if the amount values are set left side .. means that for QV are text.

BR

[qlikconsultant]

I think you are right. How can I fix it?

[qlikconsultant]

Yes they data is there and unfortunly rangesum does not work.

[GabrielAraya]

Can you give us a print screen of your table object ?

[qlikconsultant]

Hope this is enough.

[GabrielAraya · Accepted solution]

in the script try the follow for the amount field

Load
:
Replace(Amount,'.',',')          as Amount

The issue here is that the point character  is not the decmal sep.

[ecolomer]

try to punt in the pivot table one more expression with a constant value  ... example 1 and see if the values show

[qlikconsultant]

Thanks Gabriel your solution worked.