Multiple data sources in ONE straight table

[mparker123]

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?

[jmvilaplanap]

Hi

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

[mparker123]

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.