Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

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_dimperio
Specialist II
Specialist II

Hi Ashish,

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

May you post an example of Input and Output?

ashishpalkar
Creator III
Creator III
Author

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_dimperio
Specialist II
Specialist II

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
Creator III
Creator III
Author

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

OmarBenSalem

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
Partner - Master III
Partner - Master III

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_dimperio
Specialist II
Specialist II

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

Please, post some Output example

ashishpalkar
Creator III
Creator III
Author

Hi Eduardo

I am looking for individual values.