topic Re: qlik scenario in QlikView

qlik scenario

siva8 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: qlik scenario

dplr-rn — Tue, 06 Oct 2020 17:35:11 GMT

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

Re: qlik scenario

siva8 — Tue, 06 Oct 2020 18:14:54 GMT

Hi Dilipranjith,

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

thanks

siva

Re: qlik scenario

dplr-rn — Tue, 06 Oct 2020 18:18:42 GMT

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)