Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Unexpected Error on data

I don't understand why the last column is created, and as you see the circled 16,909, i what supposed the split between the months

shown.

The data is loaded from excel.

Image1.png

1 Reply
eduardo_sommer
Valued Contributor

Re: Unexpected Error on data

Hi, Gil

You probably have data with invalid dates. So when you calculate year, month, etc, the functions will return null values. Observe that the dimensions are null for this values. You can mark Suppress when Value is Null for the dimensions, but this may cause a wrong value for you, since some data will be omitted. Try to find the data that is causing the nulls in the dimensions.

Eduardo

Community Browser