topic Re: How to get column in table box in QlikView

How to get column in table box

Thu, 21 Nov 2013 13:07:17 GMT

Hi,

I have a table box and I need to show values for Dividend columns which will have data from three tables.

Table1 amount

Table 2 Commission

Table 3 Grosssalary

I need to show Dividend as (Amount+Dividend)/Grosssalary. Is there any way to get this in table box? could anyone let me know please and I have join between three tables.

Thanks.

Re: How to get column in table box

tresB — Thu, 21 Nov 2013 13:10:33 GMT

Use straight table.

Re: How to get column in table box

Thu, 21 Nov 2013 13:12:01 GMT

When I am using straight table it is showing Out Of Object memory that's the reason I changed to Table box. Any help please.

Re: How to get column in table box

tresB — Thu, 21 Nov 2013 13:16:38 GMT

Turning to table box would not be the solution (because, in table box, you can't have any calculated col/expression ). I guess there is something wrong in your modelling. Check if there is any IMproper JOIN or too many synthetic keys in the data model.

Re: How to get column in table box

Thu, 21 Nov 2013 13:18:16 GMT

Thanks and I don't have any synthetic keys in Data model and atleast if I use table box it is showing data. earlier staright table worked fine but since yesterday I was facing the problem. is this any odd issue?

Re: How to get column in table box

CELAMBARASAN — Thu, 21 Nov 2013 13:19:12 GMT

tresesco sugesstion will work.

if it says Out of object memory, then first the join between

Table1, Table 2 and Table 3

Re: How to get column in table box

CELAMBARASAN — Thu, 21 Nov 2013 13:20:11 GMT

Could you please post the image of your data model and table box?

Re: How to get column in table box

Thu, 21 Nov 2013 13:25:09 GMT

Please find attched.

Re: How to get column in table box

Josh_Good — Thu, 21 Nov 2013 22:14:47 GMT

Try filter the data down to a very small amount of data. If you still get the out of memory error than it is either a data model issue or an expression issue. If you do not get the error then it is likely your machine is under resourced for the amount of data you are dealing with.