Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Set Analysis or script

Hello All,

Here I Have Scenario

I Have Data Like 

 

Branch    ID  Fee

CSE , 120 ,  2000

CSE , 122 ,  2001

IT , 130 , 1800

IT, 133 , 1800

 

 Here i want branch wise different fees information only not required same fee entire data

 

Expected Output

Branch    ID  Fee

CSE , 120 ,  2000

CSE , 122 ,  2001

 

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Script:

t1:

Load * From <>;

Right Join

Load Fee where Count=1;

Load Count(Fee) as Count, Fee Resident t1 Group By Fee;

 

Chart:

Dim 1: Branch

Dim 2: ID

Exp : Only( {<Fee={"=Count(Fee)=1"}>} Fee) 

View solution in original post

5 Replies
Highlighted
Partner
Partner

hi 

this should work for you in a table 

if(count(distinct total <Branch> Fee)>1,Fee,0)

Highlighted
MVP
MVP

Script:

t1:

Load * From <>;

Right Join

Load Fee where Count=1;

Load Count(Fee) as Count, Fee Resident t1 Group By Fee;

 

Chart:

Dim 1: Branch

Dim 2: ID

Exp : Only( {<Fee={"=Count(Fee)=1"}>} Fee) 

View solution in original post

Highlighted
Digital Support
Digital Support

You have received two replies to your use case question, we would appreciate if you could close out the thread by using the Accept as Solution button on the response(s) that helped.  This gives the poster(s) credit for the assistance and lets other Members know what worked for you.  If you have further questions, please leave an update post.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Specialist III
Specialist III

One solution is.

tab1:
LOAD * INLINE [
    Branch, ID, Fee
    CSE, 120, 2000
    CSE, 122, 2001
    IT, 130, 1800
    IT, 133, 1800
];

Left Join(tab1)
LOAD Branch, Count(Fee) As C1_Fee, Count(DISTINCT Fee) As C2_Fee
Resident tab1
Group By Branch
;

tab2:
LOAD Branch, ID, Fee
Resident tab1
Where C1_Fee=C2_Fee
;

Drop Table tab1;
Highlighted
Specialist III
Specialist III

commQV86.PNG