Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
prasad333
New 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
Partner
Partner

Re: Relating Inline table to other tables

Dear Prasad,

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

Highlighted
prasad333
New Contributor III

Re: Relating Inline table to other tables

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

Partner
Partner

Re: Relating Inline table to other tables

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
New Contributor III

Re: Relating Inline table to other tables

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.