Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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...