Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be using Alternate States. Need more information or some sample qvw file will help to help you.
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
PLease check this once
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.
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
];
PFA
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
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
];
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