topic Re: Grab value from a table in QlikView

Grab value from a table

osni_campos — Fri, 24 Jan 2014 10:46:38 GMT

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.

Re: Grab value from a table

Fri, 24 Jan 2014 10:50:00 GMT

Osni

yes it is possible, just copy your expression in the text object.

best regards

Chris

Re: Grab value from a table

Fri, 24 Jan 2014 10:50:55 GMT

I think no, but you can use similar expression in text box to have same sum.......

Re: Grab value from a table

osni_campos — Fri, 24 Jan 2014 10:56:21 GMT

Sorry I was not clear. No need for an alternative, but actually take this value as is on the table.

using macro works, but I would not use this feature.

Re: Grab value from a table

Fri, 24 Jan 2014 11:03:05 GMT

Hi,

Yes, you can put the text as a formula. Let's say you have a table with sales amount, you want to put the total turnover in text. You can put this in text objet, for instance:

='Total turnover: '&sum(Sales)

Hope this helps

Re: Grab value from a table

Fri, 24 Jan 2014 11:19:11 GMT

Do you want the cell value for a particular cell in a row?

Well that can be done by using the same expression and using set analysis to filter the expression for that particular row.

Hope that is what you meant?

Re: Grab value from a table

osni_campos — Fri, 24 Jan 2014 11:23:46 GMT

exactly what I need.

Re: Grab value from a table

Fri, 24 Jan 2014 12:53:47 GMT

Are you able to achieve this? otherwise attach your sample app.

Let me know, if any other questions

Please close the thread if you do not have any questions

Re: Grab value from a table

peschu123 — Fri, 24 Jan 2014 13:13:12 GMT

Hi,

I have a similar problem.

I use the expressions sometimes in the Title of the Chart for example Count(Orders) when the dimension in the chart is Orders.

BUT, in my case there is often a difference between the Count() in title and the amount of Orders visible in the chart.

I think this happens when the value for the expression in the chart is null(). Then the Orders are not shown in the chart(which is totally correct) but will be counted in the title. So my title shows 10 Orders but in the chart I just see 5...

The expression in the chart title gets quite complex. It would be nice to simply reference the object ID and get the number of items shown in the chart (macro is not an option) like "GetSelectedCount"

Regards,

Peter

Re: Grab value from a table

Fri, 24 Jan 2014 13:22:48 GMT

Osni,

unless Order is an ID you should better sum(Orders)

if it is an ID, then count(distinct Orders) will give you the right number + 1 null you can remove by -1 or by set analysis {<Order=-{''}>}

best regards

Chris

Re: Grab value from a table

osni_campos — Fri, 24 Jan 2014 14:59:25 GMT

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

Re: Grab value from a table

Fri, 24 Jan 2014 15:46:13 GMT

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

Re: Grab value from a table

Fri, 24 Jan 2014 15:57:37 GMT

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

Re: Grab value from a table

peschu123 — Sat, 25 Jan 2014 11:02:09 GMT

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