Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community, I'm new to QlikView and I'm creating a pivot table where I want to compare the results of different dates and compare the last ones (like expressions) but not for all dimensions.
As all say, an image is worth than thousand words, I want to get something like this:
But when I add the expression, I get the results of each column (date)
I hope you could understand my explanation and give me some help because I don't know how to search this topic on the web.
Thank you very much
An expression will be calculated and displayed to each possible dimension-value - therefore you need to remove the horizontal dimension "Feacha" and use for each column which should be shown an own expression which then contained an additional filter/association to the dimension. Something like this:
sum({< Fecha = {'31/01/2015'}>} [Saldo Directa]) // first expression
sum({< Fecha = {'28/02/2015'}>} [Saldo Directa]) // second expression
sum({< Fecha = {'28/02/2015'}>} [Porcentaje]) // third expression
...
- Marcus