Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Try

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

View solution in original post

3 Replies
swuehl
MVP
MVP

Try

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

Anonymous
Not applicable
Author

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
Not applicable
Author

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