topic Re: Relating Inline table to other tables in App Development

Relating Inline table to other tables

prasad333 — Sat, 16 Nov 2024 21:30:04 GMT

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?

Re: Relating Inline table to other tables

arvind_patil — Thu, 31 Jan 2019 08:02:42 GMT

Dear Prasad,

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

Re: Relating Inline table to other tables

prasad333 — Thu, 31 Jan 2019 09:21:56 GMT

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

Re: Relating Inline table to other tables

arvind_patil — Thu, 31 Jan 2019 10:10:44 GMT

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

Re: Relating Inline table to other tables

prasad333 — Thu, 31 Jan 2019 12:22:55 GMT

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.