How to use more than 250 value in OR clause

[#1]

I have QVW,which records from QVD.

I need to put condition.below like

IF(GFCID='111' OR GFCID='22' OR GFCID='33' OR ....like that...I have 250 GFCID...

how achive this,PLease ahre example.

.

[jpenuliar]

try the Match() function:.

Magical Match Function in Qlikview « Learn Qlikview

[maleksafa]

simply import all the GFCID into a table with a flag next to it, let's consider the flag as 'GFCID1'

so instead of naming the GFCID in your if condition use the flag

so it will be IF(flag = 'GFCID1') where GFCID1 will represent all the GFCIDs that you mentioned.

[jpenuliar]

That makes sense, like a lookup table in excel.

Agree on that

[sujeetsingh]

Use wild match function

WIldmatch( Field,'val1','val2','val3'------)

I will suggest  you to use not equal to if the total values you are having is 300

then just use if( Wildmatch(Field, '','' ...all 50 which you do not need to include)<>1,Yes)

[MK_QSL]

Something like below

MapTable:

Mapping Load *, '1' as Flag Inline

[

  GFCID

  111

  222

  333

  666

  777

  999

];

FactTable:

Load *, ApplyMap('MapTable',GFCID,'2') as Flag Inline

[

  GFCID, NUMBER

  111, 100

  222, 200

  333, 300

  444, 400

  555, 500

  666, 600

  777, 700

  888, 800

  999, 900

];

use below expression

=SUM({<Flag = {2}>}NUMBER)

[#7]

if(match(L2GFCID,'0000546429','1000733144','1004647994','1005050649','1001955051','1005291042','1011859921','1002869965','1002134833','1004284298','1001202878',

'1001517356','1001102733','1002566288','1007918336','1004236609','1015491317','1005218795','1003015587','1000555262','1002564528','1004429008',

'1000674733','1001322873','1001699047','1002022814','1003945363','0000647314','1001732125','1003577844','1002741632','1005064321','1000597534',

'1002570633','1019229145','1011782406','1003883821','1013536208','1000278641','1001123811','1002038044','1003507927','1005552652','1000952458','1000278528',

'1001534021','1008282427','1005578473','1002054848','1005921925','0000664294','1005180518','1004577643','1008482191','1005830342','1011646464','1005741633',

'1001670375','1000100036','1000486775','1006056993','1001106399','1002895117','1002254782','1006352703','1002327968','1001844802','1000242191','1007186629',

'1006652731','1001623792','1000291664','1006675871','1000774657','1001135682','1005847709','1001791547','1001192236','1000746661','1001170003','1003950561',

'1005987896','1008569505','1006581273','1003892464','1001509361','1002731181','1004460541','1003426978','0000481947','1000285893','1002388134','1005716833',

'1003438356','1006386454','1005292618','1001586412','1005440382','1003803925','1000491752','1004104567','1008107471','1005355628','1014776849','1003828138',

'1001593745','1000860731','1001937576','1003853396','1000848588','1005518624','1005390903','1009596166','1008657315','1002258753','1003637294','1001040126',

'1000792345','1005585844','1003701022','1005213181','1002569554','1000494158','1006041945','1006909589','1003109972','1011405572','1006033438','1009782059',

'1003311399','1018493817','1001589748','1018646567','1002040146','1001832812','1001942588','1000349506','0000642169','1000457333','1008190891','1000285176',

'1017985643','1001360376','1014465487','1002748602','1002339044','0000443859','1006625505','1013349955','1009075441','1007997252','1008931565','1001994987',

'1002586602','1001162108','1003818817','1009372144','1004318389','1001482676','1005087976','1000667494','1004087492','1012930352','1001108278','1006043417',

'1008940718','1000623683','1004189759','1010797701','1001895474','1001949345','1000311452','1006603412','1007557589','1005250869','1002601628','1000508825',

'1015838406','1000593954','1005200691','1000349077','1002525751','1005738462','1003216205','1015893253','1000499702','1007040586','1004270459','1003892294',

'1017257532','1009045143','1004264017','1007718183','1002135139','1011165652','1000283394','1000935111','1000497831','1000021853','1002302418','1014355908','1003429756','1002514393','1008597746','1005716779','1013540604','1009884935',

'1002582011','1000349166','1006260108','1004810135','1001191213','1015885579','1000858311','1013473567','1014389764','1006248086','1001889555','1005908988',

'1006096863','1002416723','1000284706','1000021438','1000469307','0000534803','1003098717','1002593749','1004220419','1006101123','1000483571','1001115126',

'1003415046','0000450081','0000205958','1003867168','1008061366','1011897319','1001549231','1005286715','1001170682','1003222469','1005144058','1002772651','1006653231','1012752365','1013629184','1002377884','0000669326','1011741394','1006268109','1013999976','0000562939','1006248094','1002128779','1007062458','1001158062','1003216264',

'1004484505','1003034883','1000624981','1007391788','1016609079','1008091567','1004246051') OR L4GFCID='1001116734','NAM',

if(match(L2GFCID,1000021632','1018517201','1001775754','1000349212','1000110651','1018518054','1008062923','1006506883','1006808103','1001566993','1000020156','1000021608','1000035099','1000077247','1000076542','1000220783','1000078081','1000092491','1000245018','1000092637','1000075333','1000048735','1000455993','1000082356','1000052651','1006230098','1000021705','1001329568','1000065249','1000138505','1000049707','1000193832','1000512172','1000072962','1000059621','1000097809','1002323482','1000849339','1000451378','1009228868','1000041374','1000089334','1005413636','1001705675','1000019751','1006508231','1008522819','1004513548','1001992194','1004691489','1001185388','1001345202','1000020075','1000733829','1003790211','1004692558','9999918708','1003040484','1000878266','1001632899','1002385836','1005224523','1004657698','1000107995','1001732516','1000097701','1001840343','1000291605','1000026359','1000112859','1000291958','1001890022','1003187132','1013207832','1001563463','1000020407','1000020598','1000020539','1002568817','1000766174','1001832995','1004776484','1003703971','1003195755','1010374819','1000020547','1001627208','1009248451','1004489159','1002172921','1006319609','1000482486','1002109375','1000565144','1008307152','1000510218','1002677624','1000553804','1006594014','1004086739','1007347789','1018534769','1004672638','1008040431','1012164501','1003226219','1018455087','1000166185','1000170808','1002917846','1000170476','1013445571','1002500953','1000170921','1004324818','1001611727','1000277556','1002151924','1003232103','1000523506','1000190159','1004056902','1004118274','1005805801','1002448773','1000184906','1013904886','1007220436','1004545334','1000866152','1002534734','1003140861','1010646908','1005808231','1013915306','1005595688','1010006704','1000452315','1008228864','1001262757','1000469471','1001620637','1002064207','1002638122','1003187124','1000160144','1000109343','1000253541','1001209937','1000557559','1008118295','1004646041','1000296437','1002062247','1008424906','1007237444','1006410088','1000459263','1000197331','1004280616','1000200642','1000512369','1003890267','1003311089','1000275537','1004714829','1000201509','1006722217','1000160225','1000204028','1000449829','1002566407','1001076252','1006699002','1000207272','1002050192','1003641305','1008056958','1007755755','1002566423','1000271051','1013268815','1000523921','1000023201','1004334953','1000022418','1015515089','1000606959','1000458127','1007395643','1003878011','1009001154','1010060792','1002542877','1005091361','1006056721','1007361897','1000160063','1001505463','1000022035','1000022671','1000170387','1000189002','1000109459','1004386708','1000937106','1000442131','1006600618','1003707977','1000020822','1003012952','1001182788','1009479119','1002722573','1000278676','1004937526','1000512997','1001648132','1001668419','1013930062','1006225639','1009024235','1002073192','1000265892','1002775677','1000019964','1001748307','1004023982','1018560867','1002343327','1006600154','1002547151','1002866524','1006201667'

,'1003408945','1006266114','1000020563','1003222507','1002057634','1018517473','1009832285','1004210898','1002670476','1002337661'),'EMEA',))

How to achive below one in Qlik

[jpenuliar]

that looks like a lot of work, as Manish kachhia suggested, do a Mapping load,

maybe work your Map table in excel first, and have it load as Map.

[maleksafa]

can you upload a sample document please and we will try to help you out.

[#10]

just tell me any limition on this or not.
if yes..how will achive...because same thing in now working for OR clause.So I tried from Match function,but when I put another match fuction in nested IF...it is not rconozie.

pls don't advise on ApplyMap..

if you know tell me on this.