Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
s_alibabaei
New Contributor

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

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. 

QLIK SENSE.png

Thanks

1 Reply
MVP
MVP

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

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...