topic Re: Show Values in a Table for a Particular Field in QlikView

Show Values in a Table for a Particular Field

Tue, 17 Jun 2014 15:17:29 GMT

Hello!

I have the following tables:

Table1:

ACCOUNT_ID
INSPECTION_DATE
AMOUNT

Table2:

ACCOUNT_ID
STATUS

I want to show in a Simple Table the Table1 fields (ACCOUNT_ID, INSPECTION_DATE & AMOUNT) for those STATUS in Table2 where STATUS = Planned (STATUS could be: Selected, Planned, Inspected).

Do you know how can I do that?

Thank you!!!

Re: Show Values in a Table for a Particular Field

its_anandrjs — Tue, 17 Jun 2014 18:03:19 GMT

Try one of this load

Table1:

Load

ACCOUNT_ID,

INSPECTION_DATE,

AMOUNT

From Location;

Right Join

Table2:

Load

ACCOUNT_ID

From Location

Where Match(STATUS,'Selected', 'Planned', 'Inspected' );

In place of the right join you can try with mapping table of table2.

Re: Show Values in a Table for a Particular Field

Tue, 17 Jun 2014 18:14:29 GMT

You can try this one, kinda similar to one mentioned above -

NewTable:

Load

ACCOUNT_ID,

INSPECTION_DATE,

AMOUNT

From Table1;

Inner Join

Load

ACCOUNT_ID,

STATUS

From Table2

Where STATUS = 'Planned' ;

Thanks

Re: Show Values in a Table for a Particular Field

Anonymous — Tue, 17 Jun 2014 18:33:31 GMT

Hello.

Try using ACCOUNT_ID and INSPECTION_DATE as dimensions and this as expression:

Sum({$<STATUS = {'Planned'}>} AMOUNT)

Regards.

Re: Show Values in a Table for a Particular Field

MarcoWedel — Tue, 17 Jun 2014 20:09:34 GMT

just load your to tables as they are.

They will be associated via the ACCOUNT_ID field.

Create a tble box with the table1 fields and a listbox for the Status field.

Then select 'Planned' in the Status listbox.

hope this helps

regards

Marco

Re: Show Values in a Table for a Particular Field

its_anandrjs — Tue, 17 Jun 2014 20:56:40 GMT

May be this is your correct result try below in load script and use only Planned Status

Table1:

Load

ACCOUNT_ID,

INSPECTION_DATE,

AMOUNT

From Location;

Right Join

Table2:

Load

ACCOUNT_ID

From Location

Where Match(STATUS, 'Planned' );