Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

S

Hi,

1 Solution

Accepted Solutions
reddy-s
Master II
Master II

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.

View solution in original post

7 Replies
sunny_talwar

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'}>}

Not applicable
Author

Do you mean like this? Create flags for group1 and group2. Sorry i'm not clear what you said just now.

2016-05-17 18_34_27-_aaa test _ Data load editor - Qlik Sense.png

sunny_talwar

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

Not applicable
Author

Here I attach the qvf file if you could suggest the modification. I'm sorry for not upload it earlier.

sunny_talwar

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);

Not applicable
Author

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.

reddy-s
Master II
Master II

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.