Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with pivot table expression

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

1 Reply
marcus_sommer

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