Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...