Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
osni_campos
Contributor III
Contributor III

Grab value from a table

Good Morning

It is possible to place a text object value of a sum of a cell or expression of a particular dynamic table?

Grateful.

13 Replies
osni_campos
Contributor III
Contributor III
Author

independent expression of the formula I need to grab the value of the cell in question.

image.png

Not applicable

We can achieve this by using macros. You can call the chart and then play with its cell values.

But you need to get Value where Name is "aaaaaaa" then use

sum({<Name = {"aaaaaa"}>}Value)

or you can also try to use ranking and then fetch the row which you want. something like that may be

Not applicable

You can mark any response as Helpful Answer or if you have find your answers then mark it as Correct Answer

peschu123
Partner - Creator III
Partner - Creator III

Why should I sum a field with strings in it?

I think you got me wrong. The field orders is always filled with values. It never gets null() or empty. And even distinct counting leads not to same result like in the chart. The problem is that the expression in the chart gets null() in some cases. I will post an example in another thread. I think that will clear the situation up...

Regards,

Peter