How to get values in Table box

[#1]

Hi,

I have three tables. Employee,Department,Location

I need to create table box by using the columns from these three tables. I have link between these three tables. all is fine.

But I need to get one column Rate as like below

Amount/Purchasemoney/Claimfund.

Amount is from Employee, Purchasemoney is from Department and ClaimFund is from Location.

Could any one help me how to get this in table box.

Thanks.

[swuehl]

No calculations possible using a table box. Use a chart instead, e.g. a straight table chart.

[#3]

Thanks when I am using Straight table it's showing blank values in all columns would it be possible to get data in all columns in straight table?

[swuehl]

When using a chart, you need to decide which fields are dimensions and what aggregations to use:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/25/dimensions-and-measures

[#5]

Thanks can you help please as I am getting no idea.

[swuehl]

Well, I don't know your data, model and requirements. That's make it impossible to understand what your issue might be.

But speaking very general, choose any appropriate dimensions (the 'group by clause').

Then you need to define an appropriate expression. Consider that you need to apply an aggregation function.

So, just guessing, start with simple sums:

=sum(Amount)

etc. and check if this returns something meaningful. Note that this also depends on your data model (and for my limitations to understand, see above).

You can create more complex expressions, of course:

=sum(Amount) / sum(Purchasemoney) / sum(ClaimFund)

[CELAMBARASAN]

Analyse whether all your tables are linked correctly.

Also Create straight table with dimensions as Employee, Department, Location, Amount, Purchasemoney, Claimfund

And Expression as Amount/Purchasemoney/Claimfund.

Note: if any one of the value(Amount, Purchasemoney, Claimfund) is missing in this then result will be null

[#8]

Thanks and if I want to write the expression to get value based on

(Amount to Date+Purchasemoney)/Claimfund

how can I write expression without NULL please let me know. If possible any set analysis please