Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

alexcill
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
MVP

Re: Dimension - problem with the format

Try

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

View solution in original post

3 Replies
MVP
MVP

Re: Dimension - problem with the format

Try

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

View solution in original post

alexcill
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!

alexcill
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...