Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Qlikview and just experimenting with simple data. I have loaded a table with three columns: Date, Name and Value. I want to create a straight table which displays me a running total (Total) by Date and Name.
However the following expression does not work for me. rangesum(sum("Value"),above("Total"))
try rangesum(sum("Value"),above(sum("Value"))
or better rangesum(above(sum("Value"), 0, rowno()))
try rangesum(sum("Value"),above(sum("Value"))
or better rangesum(above(sum("Value"), 0, rowno()))
Thanks Ioannis, however the Total colum just displays the same value for the Value column. Is there anything else I need to set-up?
Actually swappign the name and Date dimensions, this works