Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table and a Graphic in QlikSense somewhat like this one in Excel:
I'd like to transform the graphic above into the below:
I tried something like creating a new Dimension like the one below but I can't seem to find a way to associete my values to each month and the sum of them to the accumulated field. How can I do it?
=If(Month='Janeiro','Janeiro',
If(Month='Fevereiro','Fevereiro',
If(Month='Março','Março',
If(Month='Abril','Abril',
If(Month='Maio','Maio',
If(Month='Junho','Junho',
If(Month='Julho','Julho',
If(Month='Agosto','Agosto',
If(Month='Setembro','Setembro',
If(Month='Outubro','Outubro',
If(Month='Novembro','Novembro',
If(Month='Dezembro','Dezembro','Acumulado'))))))))))))
Accepted Solutions
Hi @Ratier
the easy way
the hard way, using setanalysis and rangesum statement
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😁
Hi @Ratier
the easy way
the hard way, using setanalysis and rangesum statement
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😁
