topic Re: Set Analysis or script in QlikView

Set Analysis or script

Surya — Sat, 16 Nov 2024 00:45:23 GMT

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

Re: Set Analysis or script

lironbaram — Thu, 30 Apr 2020 12:13:01 GMT

this should work for you in a table

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

Re: Set Analysis or script

tresB — Thu, 30 Apr 2020 12:20:40 GMT

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)

Re: Set Analysis or script

Brett_Bleess — Tue, 26 May 2020 15:33:31 GMT

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

Re: Set Analysis or script

Saravanan_Desingh — Mon, 01 Jun 2020 00:30:11 GMT

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;

Re: Set Analysis or script

Saravanan_Desingh — Mon, 01 Jun 2020 00:31:11 GMT