Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
prasad333
Contributor III
Contributor III

Relating Inline table to other tables

Hi,

Now I have a situation where I loaded a cross table where I have data for actual and plans and when I created the cross table, in Attribute field I got the names like - Actaul, Planned, Actual1, Planned1, Actual2, Planned2.

Now to create a filter out of them, I created an Inline table as

Actual_Planned:
LOAD*inline[
Actuals, Plan
Actual,Planned
Actual1,Planned1
Actual2,Planned2
Actual3,Planned3
];

but when I am loading it, on the selection of these Actuals or Plans doesn't reflect any results on data.

Can anyone suggest how can I relate the inline table with the previous table?

4 Replies
arvind_patil
Partner
Partner

Dear Prasad,

Please Provide sample of data and output you require.
It helps to give you more accurate answer.
Thanks & Regards,
Arvind Patil

prasad333
Contributor III
Contributor III
Author

Hi Arvind,

Thank you for your response.

I have attached a sample data here.

Now with the previous question I am adding up one more - 

How to get only Brazil in a column for all the rows that will relate to all the actual and plans while loading the data.

 

Regards,

Prasad

arvind_patil
Partner
Partner

hi,

I think you need to modify table in Qliksense it is not possible to achieve in same format. refer my format for cross table.

it may help you.

Please find the attachment.

Thanks & Regards,

Arvind Patil

prasad333
Contributor III
Contributor III
Author

Hi Arvind,

Thank you for the input but the template is the same what I sent you from the client. So I can't change the format.