topic Re: left join and right join on graphics in QlikView https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035560#M465372 <HTML><HEAD></HEAD><BODY><P>Are you trying to replicate your excel result in your QlikView document?</P></BODY></HTML> Mon, 21 Mar 2016 10:57:08 GMT sunny_talwar 2016-03-21T10:57:08Z left join and right join on graphics https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035559#M465371 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Goodmorning everyone<BR /><BR />I am creating a dashboard for tracking sales.<BR /><BR />I need to have two graphs, one of the products not sold, one of the products sold out of print.<BR /><BR />I can not identify cases of null, but always all values.<BR /><BR />attached sample of the dashboard that I have to carry<BR /><BR />someone would know me out?<BR /><BR /><SPAN>Thank you</SPAN><BR /><BR />Andrew</SPAN></P></BODY></HTML> Mon, 21 Mar 2016 10:48:04 GMT https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035559#M465371 warrentk80 2016-03-21T10:48:04Z Re: left join and right join on graphics https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035560#M465372 <HTML><HEAD></HEAD><BODY><P>Are you trying to replicate your excel result in your QlikView document?</P></BODY></HTML> Mon, 21 Mar 2016 10:57:08 GMT https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035560#M465372 sunny_talwar 2016-03-21T10:57:08Z Re: left join and right join on graphics https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035561#M465373 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>Please find the attachment !</P><P>Is it that you want?</P></BODY></HTML> Mon, 21 Mar 2016 11:04:01 GMT https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035561#M465373 t_chetirbok 2016-03-21T11:04:01Z Re: left join and right join on graphics https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035562#M465374 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Please find enclosed the two tables that I would get<BR /><BR /><SPAN>thank you</SPAN></SPAN></P></BODY></HTML> Mon, 21 Mar 2016 11:11:54 GMT https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035562#M465374 warrentk80 2016-03-21T11:11:54Z Re: left join and right join on graphics https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035563#M465375 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Please find enclosed the two tables that I would get<BR /><BR /><SPAN>thank you</SPAN></SPAN></P></BODY></HTML> Mon, 21 Mar 2016 11:12:18 GMT https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035563#M465375 warrentk80 2016-03-21T11:12:18Z Re: left join and right join on graphics https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035564#M465376 <HTML><HEAD></HEAD><BODY><P>Check out the attached</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118767_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 21 Mar 2016 11:17:08 GMT https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035564#M465376 sunny_talwar 2016-03-21T11:17:08Z Re: left join and right join on graphics https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035565#M465377 <HTML><HEAD></HEAD><BODY><P>in second table use expression if(isnull(Prodotto), Quantita,0)</P></BODY></HTML> Mon, 21 Mar 2016 11:19:42 GMT https://community.qlik.com/t5/QlikView/left-join-and-right-join-on-graphics/m-p/1035565#M465377 t_chetirbok 2016-03-21T11:19:42Z