Filter data based on selected values

[qliksrikanth]

Hi Qlik community,

I want to filter the data when I select GroupA list box corresponding values (Table1,Table3,Table5) should filter. Sames as for Group B.

How can this be achieved??

Table1,Table3,Table5 - GroupA

Table2,Table4,Table6 - GroupB

Best Regards,

Srikanth

[qliksrikanth]

LOAD *, IF(Match(Table_name, 'Table1', 'Table3'), 'Set1', 'Set2') AS TableGroup

FROM TableGropu

[rwunderlich]

What is the format of the excel set files? Do the two excel files have a list of table_name, one per line?

-Rob

[shiveshsingh]

What is the error that you  are getting?

[qliksrikanth]

I am using two CSV files and combining them and trying to create attractive KPIs

Table11.csv

Table_name,table_no,total,OPEN_DATE,CLOSE_DATE

Table1,101,1000,1/12/2017  4:14:27 PM,16/01/18 12:07:27

Table3,115,6535,5/12/2017  11:38:15 PM,16/01/18 12:59:35

Table5,845,7562,11/12/2017  11:27:12 PM,16/01/18 13:02:25

Table12.csv

Table_name,table_no,total,OPEN_DATE,CLOSE_DATE

Table2,108,8000,9/1/2018  3:18:41 AM,12/1/2018  11:56:53 PM

Table4,986,12345,11/1/2018  1:18:26 AM,16/01/18 12:57:32

Table6,521,52346,27/01/18 01:18:16,27/01/18 01:20:41

LOAD *, IF(Match(Table_name, 'Table1', 'Table3'), 'Set1', 'Set2') AS TableGroup

FROM TableName //This is working correctly.

I am new to QlikView. Can you please help me to create attrative KPI's...

How to become good QlikView developer.... Any specific sites or books..... practice methods ...

Thanks

[rwunderlich]

Create the TableGroup field as you load the CSVs. For example,

Sales:

LOAD

'Set1' as TableGroup,

Table_Name,

table_no,

total...

FROM Table11.csv (,,,);

Concatenate (Sales)

LOAD

'Set2' as TableGroup,

Table_Name,

table_no,

total...

FROM Table12.csv (,,,);

-Rob