topic Re: qlik help in QlikView https://community.qlik.com/t5/QlikView/qlik-help/m-p/796422#M1034345 <HTML><HEAD></HEAD><BODY><P>please refer the attached app</P></BODY></HTML> Fri, 30 Jan 2015 10:07:30 GMT sagarkharpude 2015-01-30T10:07:30Z qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796403#M1034326 <HTML><HEAD></HEAD><BODY><P>I have below table</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt; border-collapse: collapse;" width="128"> <TBODY><TR style="height: 15pt;"> <TD height="20" style="border: 0.5pt solid silver; width: 48pt; height: 15pt; background-color: whitesmoke;" width="64"><STRONG style="font-family: Calibri;"><SPAN style="color: #363636;">INVOICE NO</SPAN><SPAN style="color: #000000; mso-spacerun: yes;"> </SPAN></STRONG></TD> <TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: silver silver silver #363636; width: 48pt; background-color: whitesmoke;" width="64"><STRONG style="font-family: Calibri;"><SPAN style="color: #363636;">PO_NO</SPAN><SPAN style="color: #000000; mso-spacerun: yes;"> </SPAN></STRONG></TD> </TR> <TR style="height: 15pt;"> <TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; width: 48pt; height: 15pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">123</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; width: 48pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">A</SPAN></TD> </TR> <TR style="height: 15pt;"> <TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; width: 48pt; height: 15pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">123</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; width: 48pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">D</SPAN></TD> </TR> <TR style="height: 15pt;"> <TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; width: 48pt; height: 15pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">123</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black silver silver black; width: 48pt; background-color: white;" width="64"><SPAN style="color: #000000; font-family: Calibri;"> </SPAN></TD> </TR> <TR style="height: 15pt;"> <TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; width: 48pt; height: 15pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">234</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; width: 48pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">B</SPAN></TD> </TR> <TR style="height: 15pt;"> <TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; width: 48pt; height: 15pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">234</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black silver silver black; width: 48pt; background-color: white;" width="64"><SPAN style="color: #000000; font-family: Calibri;"> </SPAN></TD> </TR> <TR style="height: 15pt;"> <TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; width: 48pt; height: 15pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">345</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black silver silver black; width: 48pt; background-color: white;" width="64"><SPAN style="color: #000000; font-family: Calibri;"> </SPAN></TD> </TR> <TR style="height: 15pt;"> <TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; width: 48pt; height: 15pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">456</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black silver silver black; width: 48pt; background-color: white;" width="64"><SPAN style="color: #000000; font-family: Calibri;"> </SPAN></TD> </TR> <TR style="height: 15pt;"> <TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; width: 48pt; height: 15pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">678</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; width: 48pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">D</SPAN></TD> </TR> <TR style="height: 15pt;"> <TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; width: 48pt; height: 15pt; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">678</SPAN></TD> <TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black silver silver black; width: 48pt; background-color: white;" width="64"><SPAN style="color: #000000; font-family: Calibri;"> </SPAN></TD> </TR> </TBODY></TABLE><P></P><P>when I select 123,234,678 then I don't want null value against that invc number if I selecting 345,456 then it should show me null po number for that invc number</P><P></P><P>Thanks</P></BODY></HTML> Fri, 30 Jan 2015 08:48:26 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796403#M1034326 Anonymous 2015-01-30T08:48:26Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796404#M1034327 <HTML><HEAD></HEAD><BODY><P>Take a look at this example</P></BODY></HTML> Fri, 30 Jan 2015 08:55:16 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796404#M1034327 alexandros17 2015-01-30T08:55:16Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796405#M1034328 <HTML><HEAD></HEAD><BODY><P>output is not coming as I want</P></BODY></HTML> Fri, 30 Jan 2015 08:59:12 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796405#M1034328 Anonymous 2015-01-30T08:59:12Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796406#M1034329 <HTML><HEAD></HEAD><BODY><P>Send me your example document please</P></BODY></HTML> Fri, 30 Jan 2015 09:00:27 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796406#M1034329 alexandros17 2015-01-30T09:00:27Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796407#M1034330 <HTML><HEAD></HEAD><BODY><P>Hi..</P></BODY></HTML> Fri, 30 Jan 2015 09:05:51 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796407#M1034330 Anonymous 2015-01-30T09:05:51Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796408#M1034331 <HTML><HEAD></HEAD><BODY><P>any help?</P></BODY></HTML> Fri, 30 Jan 2015 09:15:18 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796408#M1034331 Anonymous 2015-01-30T09:15:18Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796409#M1034332 <HTML><HEAD></HEAD><BODY><P>try this in listbox</P><P>=if(Len(PO_NO)&gt;0,PO_NO)</P></BODY></HTML> Fri, 30 Jan 2015 09:21:42 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796409#M1034332 arulsettu 2015-01-30T09:21:42Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796410#M1034333 <HTML><HEAD></HEAD><BODY><P>=if(IsNull(PO_NO)=-1,'Null',PO_NO)</P></BODY></HTML> Fri, 30 Jan 2015 09:24:12 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796410#M1034333 sagarkharpude 2015-01-30T09:24:12Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796411#M1034334 <HTML><HEAD></HEAD><BODY><P>hi sagaer,</P><P></P><P>where I need to put this expression </P></BODY></HTML> Fri, 30 Jan 2015 09:25:12 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796411#M1034334 Anonymous 2015-01-30T09:25:12Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796412#M1034335 <HTML><HEAD></HEAD><BODY><P>not working above functions</P></BODY></HTML> Fri, 30 Jan 2015 09:26:30 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796412#M1034335 Anonymous 2015-01-30T09:26:30Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796413#M1034336 <HTML><HEAD></HEAD><BODY><P>what you are trying to achieve?</P><P>if you select invoice it should not show any null values right?</P></BODY></HTML> Fri, 30 Jan 2015 09:28:45 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796413#M1034336 arulsettu 2015-01-30T09:28:45Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796414#M1034337 <HTML><HEAD></HEAD><BODY><P>no ..</P><P></P><P>when I select 123,234,678 then I don't want null value against that invc number</P><P>and</P><P> if I selecting 345,456 then it should show me null po for that invc number</P></BODY></HTML> Fri, 30 Jan 2015 09:31:17 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796414#M1034337 Anonymous 2015-01-30T09:31:17Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796415#M1034338 <HTML><HEAD></HEAD><BODY><P>when I trying</P><P>=if(IsNull(PO_NO)=-1,'Null',PO_NO)</P><P>then it will come but not for 123</P></BODY></HTML> Fri, 30 Jan 2015 09:32:40 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796415#M1034338 Anonymous 2015-01-30T09:32:40Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796416#M1034339 <HTML><HEAD></HEAD><BODY><P>Put these expression in expression tab. In dim you will have Invoice number and PO number</P></BODY></HTML> Fri, 30 Jan 2015 09:35:05 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796416#M1034339 sagarkharpude 2015-01-30T09:35:05Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796417#M1034340 <HTML><HEAD></HEAD><BODY><P>not coming</P></BODY></HTML> Fri, 30 Jan 2015 09:37:08 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796417#M1034340 Anonymous 2015-01-30T09:37:08Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796418#M1034341 <HTML><HEAD></HEAD><BODY><P><IMG alt="Untitled.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76704_Untitled.png" style="width: 620px; height: 260px;" /></P><P>if I select 123 then I don't want selected red portion </P></BODY></HTML> Fri, 30 Jan 2015 09:44:31 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796418#M1034341 Anonymous 2015-01-30T09:44:31Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796419#M1034342 <HTML><HEAD></HEAD><BODY><P>Very Sorry to all of you.....</P><P></P><P></P><P><IMG alt="Untitled.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/76690_Untitled.png" style="width: 620px; height: 260px;" />I</P><P></P><P></P><P>I don't want above records.</P></BODY></HTML> Fri, 30 Jan 2015 09:50:48 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796419#M1034342 Anonymous 2015-01-30T09:50:48Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796420#M1034343 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P>=if(GetFieldSelections([INVOICE NO])&gt;0 or IsNull(PO_NO)=0,PO_NO,'Null')</P></BODY></HTML> Fri, 30 Jan 2015 09:56:27 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796420#M1034343 sagarkharpude 2015-01-30T09:56:27Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796421#M1034344 <HTML><HEAD></HEAD><BODY><P>123 A</P><P>123 D</P><P></P><P>is not coming.</P></BODY></HTML> Fri, 30 Jan 2015 10:01:55 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796421#M1034344 Anonymous 2015-01-30T10:01:55Z Re: qlik help https://community.qlik.com/t5/QlikView/qlik-help/m-p/796422#M1034345 <HTML><HEAD></HEAD><BODY><P>please refer the attached app</P></BODY></HTML> Fri, 30 Jan 2015 10:07:30 GMT https://community.qlik.com/t5/QlikView/qlik-help/m-p/796422#M1034345 sagarkharpude 2015-01-30T10:07:30Z