topic Re: Two Tables, One Graph in QlikView

Two Tables, One Graph

gfisch13 — Wed, 25 Nov 2020 16:16:04 GMT

Good morning everyone -

I have a situation where I want to report on two different data sources on the same graph. Last year my company changed corporate credit cards. I want to compare the spending levels by month. I've created a simple bar graph with the first data source, dimension is Month, expression is SUM(TRAN_AMT).

In the second data source I've created the month field but with a slightly different name. But when I try to add to the graph I'm unsure how to represent the new data. Plus, I cannot select values from list boxes that represent the first source, with values from the second source.

Any guidance would help............Appreciate the time an attention.

Thanks,

George

Re: Two Tables, One Graph

kumarkp412 — Mon, 30 Jan 2017 14:27:49 GMT

Hi George,

I hope this could be arrive based on mismatching the realation .

I hope you will have the relation ship between the two datasources. If yes, then onceagin recheck the relation between the two datasources.

Can you upload a sample for better understaning and resolving you issue.

Thanks

Kumar KVP

Re: Two Tables, One Graph

gfisch13 — Mon, 30 Jan 2017 17:57:53 GMT

Hi Kumar - the only relationship I can see here would be month/year. Cannot see anything else that would relate.........other than employee there is really no other relation.

I'm sorry, I cannot upload a sample for this.

Thanks!

Re: Two Tables, One Graph

anlonghi2 — Fri, 10 Feb 2017 18:21:04 GMT

Hello George,

you can try executing a concat between the first data source (Citi) and the second one (Amex) renaming the Amex field as Citi fields, remapping TRAN_TYP_CD codes on TRAN_CD_GRP and creating a field (ex.: CC_Brand) with 'Citi' value for Citi and 'Amex' for Amex data.

Please look at the script of attached app.

Best regards