Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am new to Qlik sense.
Currently want to try out some data.
I have problem to filter a specific text such as "add" and then count the total number of "add" and show in a table.
My data will be in a column and show, S_add, Add_test, A_test_add, S_test and etc.
Can anyone can me with this?
Thanks in advance.
=sum(if(index(ColumnName,'add')>0,1,0))
Hi,
Tried not working.
Below is roughly how the table look like.
Item Date Files
EQ1 2019/08/14 A_add
EQ2 2019/08/15 A_add_test
EQ3 2019/08/16 A_test
EQ3 2019/09/15 A_S_Add
EQ1 2019/09/14 A_Test_Add
EQ1 2019/09/15 A_test
EQ3 2019/07/14 A_test
EQ2 2019/07/15 A_Test_Add
EQ1 2019/07/15 A_Test_Add
EQ3 2019/08/11 A_Test_Add
EQ2 2019/08/11 A_add
EQ2 2019/08/16 A_add
EQ3 2019/09/11 A_add
EQ1 2019/09/11 A_add
EQ3 2019/07/10 A_test
EQ2 2019/08/10 A_test
I have difference items, date and file.
I would like to filter the items in one group with date and total number of "add"
Hi,
Not working..
Hi,
Maybe to have clearer picture of what i want.
Items Date Files
EQ1 2019/01/01 S_add
EQ1 2019/01/02 Add_Test
EQ3 2019/01/02 S_Test_add
EQ2 2019/02/02 Add_Test
EQ1 2019/02/01 S_Test
EQ3 2019/03/02 A_Test
EQ2 2019/03/02 S_add
EQ2 2019/02/02 Add_Test
EQ3 2019/01/01 S_add_test
EQ1 2019/02/05 Add_Test
EQ1 2019/01/10 S_add_test
EQ3 2019/03/22 A_Add_Test
EQ3 2019/03/01 S_Test
EQ2 2019/01/22 A_Test
I need to group the data in month with "add" in diff Items group.
May I know if there is any problem?
I need the script.
Thank you very much for the help.
Try like below
T:
Load Items,Date(Date#(Date,'YYYY/MM/DD'),'YYYY/MM/DD') as Date,Files,if(wildmatch(Files, '*add*')>0,1,0) as Files_Count;
Load * Inline [
Items,Date,Files
EQ1,2019/01/01,S_add
EQ1,2019/01/02,Add_Test
EQ3,2019/01/02,S_Test_add
EQ2,2019/02/02,Add_Test
EQ1,2019/02/01,S_Test
EQ3,2019/03/02,A_Test
EQ2,2019/03/02,S_add
EQ2,2019/02/02,Add_Test
EQ3,2019/01/01,S_add_test
EQ1,2019/02/05,Add_Test
EQ1,2019/01/10,S_add_test
EQ3,2019/03/22,A_Add_Test
EQ3,2019/03/01,S_Test
EQ2,2019/01/22,A_Test
];
T:
Load
Month(Date) as Month,
sum(Files_Count) as Total_Conut
Resident T
Group by Month(Date);
Hi,
Below table is an example. I have full long list of data.
Thanks for the help.
Hi,
Tried. Not working.
My data can go up to thousands.
if(wildmatch(Files, '*add*')>0,Files) -----> this work
count (if(wildmatch(Files, '*add*')>0,Files)) -----------> this cannot work. Tried it.
for counting maybe ?
Sum (if(wildmatch(Files, '*add*')>0,1))