topic Re: exclude value in QlikView

exclude value

raadwiptec — Wed, 14 Oct 2015 11:12:45 GMT

hi all,

I have a scenarie where I display the data based on few id and year

for eg:

id ¦ yearmm

1 ¦ 201501

2!201502

3!201503

4!201504

5!2015 05

now I would like to add id =6 but it should diplay values only starting from yearmm- 201205 ..even though if it has data from past months

avinashelite — Wed, 14 Oct 2015 11:23:48 GMT

try like this

if(yearmm>'201205',id)

raadwiptec — Wed, 14 Oct 2015 11:25:54 GMT

hi avinash

I only need to do this for id =6 rest of them it should show as usual all the previous months

avinashelite — Wed, 14 Oct 2015 11:28:13 GMT

i did not get you, can you please elaborate bit more with the output your excepting

Kushal_Chawda — Wed, 14 Oct 2015 11:35:24 GMT

try,

Data:

load id,

yearmm

if( id=6 and yearmm>=201505,1,if(id<>6 ,0) ) as FlagId6

From Table;

Final:

noconcatenate

load *

resident Data

where FlagId6=0;

concatenate(Final)

load *

resident Data

where FlagId6=1;

drop table Data;

raajaswin — Wed, 14 Oct 2015 11:44:41 GMT

I think this will work

=pick(match(id,'6')+1,if(yearmm>'201205',yearmm,'year mm condition fails'),yearmm)