topic Re: Dimension - problem with the format in QlikView

Dimension - problem with the format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

swuehl — Sat, 07 Oct 2017 20:36:19 GMT

Try

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

Anonymous — Sat, 07 Oct 2017 21:09:35 GMT

Bingo, actually I needed

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

but you respeonse did it!

Anonymous — Thu, 26 Oct 2017 17:46:38 GMT

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