topic Help with pivot table expression in QlikView

Help with pivot table expression

Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Help with pivot table expression

marcus_sommer — Sun, 21 Jun 2015 07:59:38 GMT

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