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

[vishsaggi]

May be using Alternate States. Need more information or some sample qvw file will help to help you.

[qliksrikanth]

For example:

Table_name,table_no,total

Table1,101,1000

Table2,108,8000

Table3,115,6535

Table4,986,12345

Table5,845,7562

Table6,521,52346

[shiveshsingh]

PLease check this once

what is alternate states in Qlikview ?

[qliksrikanth]

No I am not looking for alternate states.

I will combine two excel sheets. Output will be look like example as I had provided above.

Table_name,table_no,total

Table1,101,1000

Table2,108,8000

Table3,115,6535

Table4,986,12345

Table5,845,7562

Table6,521,52346

I want filter data using check boxes...like set1(Table1,Table3,Table5), set2(Table2,Table4,Table6)

If I select set2 - Table_name vales Table2,4,6 should load....

How to do this..? ?

Let me if u need more data.

[vishsaggi]

Try this?

LOAD *, IF(Match(Table_name, 'Table1', 'Table3', 'Table5'), 'Group1', 'Group2') AS TableGroup INLINE [

Table_name,table_no,total

Table1,101,1000

Table2,108,8000

Table3,115,6535

Table4,986,12345

Table5,845,7562

Table6,521,52346

];

[shiveshsingh]

PFA

[rwunderlich]

LOAD * INLINE [

Table_name,table_no,total

Table1,101,1000

Table2,108,8000

Table3,115,6535

Table4,986,12345

Table5,845,7562

Table6,521,52346

];

GroupTable:

LOAD * INLINE [

Table_name, Group

Table1,GroupA

Table2, GroupB

Table3, GroupA

Table4,GroupB

Table5,GroupA

Table6,GroupB

];

And then make a listbox for Group.

-Rob

[ravikumar89]

Hi,

Try with Flags. am not sure about it, in case it is wrong please let me know

FLAG1:

load *, 'GroupA' as FLAG

inline[

Table_name,table_no,total

Table1,101,1000

Table3,115,6535

Table5, 845,7562

];

FLAG2:

load *,'GroupB' as FLAG

Table_name,table_no,total

Table2,108,8000

Table4,986,12345

Table6,521,52346

];

[qliksrikanth]

Thanks for your response.

Table_name,table_no,total

Table1,101,1000

Table2,108,8000

Table3,115,6535

Table4,986,12345

Table5,845,7562

Table6,521,52346

set1(Table1,Table3,Table5)

set2(Table2,Table4,Table6)

I am pulling data from two excels called set1 & set2. If i add any new data its not working.

Can anyone please help