Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

How to get cell value from table

‌Hi there

i am trting to get cell value from the stra table.

can you suggest how to get it.

8 Replies
eduardo_dimperi
Valued Contributor II

Re: How to get cell value from table

Hi Ashish,

I dont understand what you need, what's a stra table?

May you post an example of Input and Output?

ashishpalkar
Contributor II

Re: How to get cell value from table

Hi Eduardo


Thanks for the updates, please find attached screenshot for your reference.

I have straight table and I am trying to get the specific cell value from that straight table.

eduardo_dimperi
Valued Contributor II

Re: How to get cell value from table

Ashish,

If you want just show this value you can use # KPI on left corner and use the SUM() function

If you want store that you can use the same SUM() function on script.

kpi.JPG

ashishpalkar
Contributor II

Re: How to get cell value from table

Thanks , how about if I want 2nd or 3rd value from that column?

OmarBenSalem
Esteemed Contributor

Re: How to get cell value from table

you have to precise which value you want to work with:

I mean if you want sum(Sales) for the product = american beef bologna

you have to precise it in your expression (in the KPI)

Sum( {<Product={'American beef Bologna'}>}Sales)

Qlik is case sensitive; so u have to write it as it is !

and try to seach in google for "set expression qlik" , you'll find some good tutorials to guide you through such expressions

shraddha_g
Honored Contributor III

Re: How to get cell value from table

You will have to add conditions in Set analysis according to your requirement.

For Set Analysis:  Learning Set Analysis from Scratch

Set Analysis: syntaxes, examples

Set Analysis Presentation.pdf

eduardo_dimperi
Valued Contributor II

Re: How to get cell value from table

Dont understand, you want the Sum of all values or individual values?

Please, post some Output example

ashishpalkar
Contributor II

Re: How to get cell value from table

Hi Eduardo

I am looking for individual values.

Community Browser