topic Re: How to get values in Table box in QlikView

How to get values in Table box

Wed, 16 Oct 2013 08:59:14 GMT

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.

Re: How to get values in Table box

swuehl — Wed, 16 Oct 2013 09:22:32 GMT

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

Re: How to get values in Table box

Wed, 16 Oct 2013 09:23:40 GMT

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?

Re: How to get values in Table box

swuehl — Wed, 16 Oct 2013 09:25:54 GMT

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

Re: How to get values in Table box

Wed, 16 Oct 2013 09:40:11 GMT

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

Re: How to get values in Table box

swuehl — Wed, 16 Oct 2013 09:49:15 GMT

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)

Re: How to get values in Table box

CELAMBARASAN — Wed, 16 Oct 2013 09:50:59 GMT

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

Re: How to get values in Table box

Wed, 16 Oct 2013 10:00:50 GMT

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