topic Re: Multiple data sources in ONE straight table in QlikView

Multiple data sources in ONE straight table

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

Hello Everyone,

I have two data sources talking to the same script in QlikView. One is coming in from an ODBC (JIRA) and the other is just a table file from excel. I am trying to show both sets of data on the same straight table. Is this at all possible in QlikView? If so, how would you write an expression that will show both?

Re: Multiple data sources in ONE straight table

jmvilaplanap — Mon, 10 Jul 2017 14:03:35 GMT

There is no problem to show all the data in a single table, but be careful about it. If the data is not related and the data is huge (hundreds of million rows) you can freeze the computer.

Could you share your data model?

Regards

Re: Multiple data sources in ONE straight table

mparker123 — Mon, 10 Jul 2017 14:28:56 GMT

How would i go about showing the data?

Only({$<issue_type={"New Client"},issue_status-={"Not Required","Done"},project_name-={"PMO Test"},issue_summary-={"Test Ticket"}>}issue_assignee) and Only({<issue_type={"New Client"}>}[issue assignee])

This is the expression i am trying to use to show BOTH sets of data in the same straight table. I linked issue type together (which is why it appears the same in both formulas. This formula is not showing me both sets of data though, just the ODBC data.