How to extract the value from the specific cells in table? Qlik Sense

Anonymous — Sun, 03 Sep 2017 09:21:40 GMT

Hi,

how can extract the value from the specific cells in table?

For example, where "Description" is "D" and Colonne is "Feb", I want to get the value : 111,0.

Thanks

Re: How to extract the value from the specific cells in table? Qlik Sense

petter — Sun, 03 Sep 2017 15:43:52 GMT

If table refers to a table in memory that looks like the one you depicted here:

To get the value you can use an expression likes this:

Sum( {<Description={'D'} Feb )

If the table is pivoted from it's in-memory representation and actually looks like this

Description Month, Val

A, Jan,

A, Feb, 27,86

.....

Then this can be done to extract the value:

Sum( {<Description={'D'},Month={'Feb'}>} Val)

There is also a number of inter-record (within a chart) functions that can be used within the table to refer to other rows and columns to get cell-values: Above(), Below(), Before(), After() ..... and more: http://help.qlik.com/en-US/sense/June2017/Subsystems/Hub/Content/ChartFunctions/InterRecordFunctions/inter-record-functions-charts.htm