Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Hi Kamarul,
I would suggest you to concatenate all the three table like this:
MainGroup:
LOAD Id,
Name,
Status,
'Main' as Flag
FROM [lib://Desktop/Main group.xlsx]
(ooxml, embedded labels, table is Sheet1);
Concatenate(MainGroup)
Group1:
LOAD Id,
Name,
Status,
'Group1' as Flag
FROM [lib://Desktop/Group1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Concatenate(MainGroup)
LOAD
Id,
Name,
Status,
'Group2' as Flag
FROM [lib://Desktop/Group2.xlsx]
(ooxml, embedded labels, table is Sheet1);
Now if you use count([status]) as the expression and use two filters : Flag and ID, you will be able to acheive what you are looking for.
Thanks,
Sangram.
Create flags for each of the tables
Group1:
LOAD *,
'Group1' as Flag
FROM Source;
Group2:
LOAD *,
'Group2' as Flag
FROM Source2;
Now you can use set analysis to show stuff from Group1 using a set analysis like this:
{<Flag = {'Group1'}>}
Do you mean like this? Create flags for group1 and group2. Sorry i'm not clear what you said just now.
Yes and no. The way to create the flag is right, but would script it a little differently. You pasted the script as image and hence won't be able to suggest any modifications
Here I attach the qvf file if you could suggest the modification. I'm sorry for not upload it earlier.
May be something like this:
MainGroup:
LOAD Id,
Name,
Status
FROM [lib://Desktop/Main group.xlsx]
(ooxml, embedded labels, table is Sheet1);
Group1:
LOAD Id,
Name,
Status,
'Group1' as Flag
FROM [lib://Desktop/Group1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Concatenate(Group1)
LOAD
Id,
Name,
Status,
'Group2' as Flag
FROM [lib://Desktop/Group2.xlsx]
(ooxml, embedded labels, table is Sheet1);
I really appreciate your help. but i still not understand yet how to count status 'single' from main group which id belong to group1. The syntax that i want to create is like below :
Count id(main group) =id(group1) where status='Single'.
Could you convert my syntax to qlik sense syntax.
Hi Kamarul,
I would suggest you to concatenate all the three table like this:
MainGroup:
LOAD Id,
Name,
Status,
'Main' as Flag
FROM [lib://Desktop/Main group.xlsx]
(ooxml, embedded labels, table is Sheet1);
Concatenate(MainGroup)
Group1:
LOAD Id,
Name,
Status,
'Group1' as Flag
FROM [lib://Desktop/Group1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Concatenate(MainGroup)
LOAD
Id,
Name,
Status,
'Group2' as Flag
FROM [lib://Desktop/Group2.xlsx]
(ooxml, embedded labels, table is Sheet1);
Now if you use count([status]) as the expression and use two filters : Flag and ID, you will be able to acheive what you are looking for.
Thanks,
Sangram.