topic Re: Chart with Dimensions in different tables in QlikView

Chart with Dimensions in different tables

gerhardl — Tue, 08 Jan 2013 11:08:09 GMT

Hi There,

I have two fields from two different tables.

Field 1 is the "Decision Date" and it comes from the Applications Table.

Field 2 is the "Date of First Purchase" and it comes from the Accounts Table.

I do a report in Excel (from QlikView data). In this report I have a chart which shows, PER DAY, what percentage of the accounts have Activated (made a purchase).

Please see my attached image.

1. I have a straight table with Decision Date as dimension where I cumulatively count the applications. This gives my the campaign's Account Base Size per day.

2. I have a straight table with Date of First Purchase as dimension where I cumulatively count the Accounts. this gives me the number of Activated accounts per day.

If on DAY 1 I have 100 accounts and 80 Activations, then the Activation Rate on DAY 1 is 80%.

This I calculate in excel doing a vLookup on the DATE.

How can I do this in QlikView? I want one chart/table where I have a date, and I can see how many accounts I had at that time and how many are activated.

Please help!

Re: Chart with Dimensions in different tables

Gysbert_Wassenaar — Tue, 08 Jan 2013 11:16:11 GMT

If you give your dates fields the same name in both tables, then qlikview will be able to associate your tables. You can then use the date field as dimension in your chart and the expression Approvals/Accounts to calculate the activation rate. Or maybe rangesum(above(sum(Approval),0,rowno()))/rangesum(above(sum(Accounts),0,rowno())). It's not entirely clear to me what you're trying to calculate.

Re: Chart with Dimensions in different tables

gerhardl — Tue, 08 Jan 2013 11:22:12 GMT

Hi Gysbert,

I was also playing around with this idea. I don't think it is technically "correct" but I don't really know why I think so.

I'm going to try this (but create a new key field on both tables) and see what happens. I'll have to rerun my QVD's so it will take an hour or so, then I'll see if it works and let you know.

Thanks

P.S - are you Afrikaans or Dutch?

Re: Chart with Dimensions in different tables

gerhardl — Tue, 08 Jan 2013 12:49:26 GMT

I'm afraid this doesn't work.

It gives me skewed data, with figures way too low.