# New to QlikView

Discussion board where members can get started with QlikView.

New Contributor III

## Dimension - problem with the format

I have this extension that shows sales of certain year, month and deending on it's origen, it works fine:

Sum ({<Y = {"\$(=[Año columna 1])"} , M = {"\$(=[Hasta mes])"}, Origen = {"\$(=[Origen 1])"}>}[Venta Neta Factura])

Now I want to add another dimension with YTD sales so I 've tried this, just adding <:

Sum ({<Y = {"\$(=[Año columna 1])"} , M = {"\$(<=[Hasta mes])"}, Origen = {"\$(=[Origen 1])"}>}[Venta Neta Factura])

but it retruns 0

Has it somethingto do with a format problem??? M is a number, form 1 until 12...

1 Solution

Accepted Solutions
MVP

## Re: Dimension - problem with the format

Try

Sum ({<Y = {"\$(=[Año columna 1])"} , M = {"<\$(=[Hasta mes])"}, Origen = {"\$(=[Origen 1])"}>}[Venta Neta Factura])

3 Replies
MVP

## Re: Dimension - problem with the format

Try

Sum ({<Y = {"\$(=[Año columna 1])"} , M = {"<\$(=[Hasta mes])"}, Origen = {"\$(=[Origen 1])"}>}[Venta Neta Factura])

New Contributor III

## Re: Dimension - problem with the format

Bingo, actually I needed

Sum ({<Y = {"\$(=[Año columna 1])"} , M = {"<=\$(=[Hasta mes])"}, Origen = {"\$(=[Origen 1])"}>}[Venta Neta Factura])

but you respeonse did it!

New Contributor III

## Re: Dimension - problem with the format

Great! You just saved me several hours or trying... Maybe I should read some manuals because I should control better these problems...