topic Re: Filter data based on selected values in QlikView

Filter data based on selected values

qliksrikanth — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Filter data based on selected values

vishsaggi — Fri, 01 Jun 2018 16:20:50 GMT

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

Re: Filter data based on selected values

qliksrikanth — Fri, 01 Jun 2018 16:39:36 GMT

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

Re: Filter data based on selected values

shiveshsingh — Fri, 01 Jun 2018 17:09:46 GMT

PLease check this once

what is alternate states in Qlikview ?

Re: Filter data based on selected values

qliksrikanth — Fri, 01 Jun 2018 17:54:02 GMT

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.

Re: Filter data based on selected values

vishsaggi — Fri, 01 Jun 2018 18:29:59 GMT

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

];

Re: Filter data based on selected values

shiveshsingh — Sat, 02 Jun 2018 09:24:05 GMT

PFA

Re: Filter data based on selected values

rwunderlich — Sun, 03 Jun 2018 16:21:48 GMT

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

Re: Filter data based on selected values

ravikumar89 — Mon, 04 Jun 2018 04:41:05 GMT

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

];

Re: Filter data based on selected values

qliksrikanth — Tue, 05 Jun 2018 06:00:18 GMT

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

Re: Filter data based on selected values

qliksrikanth — Tue, 05 Jun 2018 06:16:31 GMT

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

FROM TableGropu

Re: Filter data based on selected values

rwunderlich — Tue, 05 Jun 2018 16:35:10 GMT

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

-Rob

Re: Filter data based on selected values

shiveshsingh — Tue, 05 Jun 2018 17:15:26 GMT

What is the error that you are getting?

Re: Filter data based on selected values

qliksrikanth — Wed, 06 Jun 2018 11:23:28 GMT

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

Re: Filter data based on selected values

rwunderlich — Wed, 06 Jun 2018 16:36:31 GMT

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