topic Nested IF makes proccessing havier for a straight table in QlikView https://community.qlik.com/t5/QlikView/Nested-IF-makes-proccessing-havier-for-a-straight-table/m-p/1187389#M885265 <HTML><HEAD></HEAD><BODY><P>Hy there , I have a Straight table with 4 dimensions . For each dimension I have calculated what to show using nested if statement.</P><P>The statement looks something like this : </P><P>if(Match(ID,GetFieldSelections(ID)),ID,if(Match(NO,GetFieldSelections(NO)),ID,if(Match(DATE,GetFieldSelections(DATE)),ID)))</P><P>But this nested IF`s makes the proccessing real heavy . Is there any other way to acomplish the same behavior without using this calculated dimmension?</P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT razvan_brais 2020-11-25T16:16:04Z Nested IF makes proccessing havier for a straight table https://community.qlik.com/t5/QlikView/Nested-IF-makes-proccessing-havier-for-a-straight-table/m-p/1187389#M885265 <HTML><HEAD></HEAD><BODY><P>Hy there , I have a Straight table with 4 dimensions . For each dimension I have calculated what to show using nested if statement.</P><P>The statement looks something like this : </P><P>if(Match(ID,GetFieldSelections(ID)),ID,if(Match(NO,GetFieldSelections(NO)),ID,if(Match(DATE,GetFieldSelections(DATE)),ID)))</P><P>But this nested IF`s makes the proccessing real heavy . Is there any other way to acomplish the same behavior without using this calculated dimmension?</P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Nested-IF-makes-proccessing-havier-for-a-straight-table/m-p/1187389#M885265 razvan_brais 2020-11-25T16:16:04Z