Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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