Relating Inline table to other tables

[prasad333]

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?

[arvind_patil]

Dear Prasad,

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

[prasad333]

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]

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]

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.