topic Re: Trouble with a pivote table in QlikView

Trouble with a pivote table

qlikconsultant — Wed, 06 Aug 2014 20:59:40 GMT

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 — Wed, 06 Aug 2014 21:03:50 GMT

try with RangeSum(amount)

¿are you sure about the data?

GabrielAraya — Wed, 06 Aug 2014 21:12:07 GMT

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

qlikconsultant — Wed, 06 Aug 2014 21:22:39 GMT

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

qlikconsultant — Wed, 06 Aug 2014 21:23:32 GMT

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

GabrielAraya — Wed, 06 Aug 2014 21:25:29 GMT

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

qlikconsultant — Wed, 06 Aug 2014 21:30:53 GMT

Hope this is enough.

GabrielAraya — Wed, 06 Aug 2014 21:34:24 GMT

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 — Wed, 06 Aug 2014 21:36:37 GMT

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

qlikconsultant — Wed, 06 Aug 2014 21:40:19 GMT

Thanks Gabriel your solution worked.