qlik scenario

[siva8]

Hi Team,

can u please help me with the below requirement 

i have table like below

flag	cc	total
	same	2
b	same	3
f	same	4
b	notsame	4
f	notsame	5

i have to  ignore  records  where (flag =b and cc = same) and   where (flag =f and  cc =same)

output:

flag	cc	total
	same	2
b	notsame	4
f	notsame	5

Thanks in advance 

Regards

siva 

[dplr-rn]

do you need to do it on the table or script?

[siva8]

Hi Dilipranjith,

in script while loading the table i have to ignore  records  based on above  mentioned where clause 

thanks 

siva

[dplr-rn · Accepted solution]

in script

load *
where not (flag='b' and cc='same') and not  (flag='f' and cc='same')
;
load * inline [
flag,cc,total
 	,same,2
b,same,3
f,same,4
b,notsame,4
f,notsame,5
];

on chart 2 options.

1-set analysis - something like below the - eliminates the combiantions

=Only(
{

-<flag={'b'},cc={'same'}>
-<flag={'f'},cc={'same'}>
}
total)

2-If statement - create a dimension like below and suppress when value is null

=if((flag='b' and cc='same')or (flag='f' and cc='same'),null(),flag)