topic Re: How overlay two graphic with different dimension? in QlikView

How overlay two graphic with different dimension?

Thu, 17 May 2012 11:06:37 GMT

I would like to draw these two graphics together without reload data (It's difficult to create a commune dimension: I have two similar dimensions and tho similars metrics)

Is it posible?

Thank you very much!

Re: How overlay two graphic with different dimension?

IAMDV — Thu, 17 May 2012 22:39:57 GMT

Hi,

Sorry, I didn't understand it completely. You don't want load the dimension dates but you wanted to created the dates dynamically, is this right? Please can you explain in detail.

Thanks,

Re: How overlay two graphic with different dimension?

Fri, 18 May 2012 07:21:15 GMT

Sorry for my poor English, I'm trying to improve it

My problem is that I have two tables like this:

table 1

iduser

date_earning

cash_earning

table 2

iduser

date_spending

cash_spending

and other tables with iduser...

If I have to do a simple chart with sum(cash_earning) by data_earning or sum(cash_spending) by data_spending I wouldn't have problem (attached charts)

My problem appears when I try to put this two charts together in one simple chart because if I chose "data_earning" from table 1, sum(cash_spending) don't work and viceversa.

Anyway I found a solution to solve and avoid cartessian product... I load the tables two times, once with the right name dimension: data_earning and data_spending and other renaming these two dimension as "date"

I use the new date dimension to put sum(cash_earning) and sum(cash_spending) together (join tables by iduser and new date dimension)

I'm happy because I resolve it but I think that perhaps isn't necessary to load two times the same data.

I hope you understand me

Thank you!

Agustín

How overlay two graphic with different dimension?

Fri, 18 May 2012 08:43:10 GMT

Hi cannolade...

If you want to show the both trends in single chart with same dimension then select the combo chart and use both the expressions in a single chart . Hope this works..

regards,

Susvith Reddy

Re: How overlay two graphic with different dimension?

Nicole-Smith — Fri, 18 May 2012 17:46:10 GMT

In my attached example, I joined the two tables together without having to load them twice. I believe this gives your desired result. Hopefully this is helpful for you!

Re: How overlay two graphic with different dimension?

Fri, 18 May 2012 17:59:32 GMT

You could also concatenate the tables together (you would have to rename the date fields to have the same name). This would also allow you to easily determine total spend or earn counts by user and/or date.