topic Re: Adding values if no data is available in QlikView https://community.qlik.com/t5/QlikView/Adding-values-if-no-data-is-available/m-p/886039#M998298 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>It depends on your model. If you have table with plans and facts then you already have data values for Jun-Apr.</P><P>If you keep plans in the different table then you can put some "zero" rows into your sale table.</P><P></P><P>Can you attach your model?</P></BODY></HTML> Mon, 15 Jun 2015 10:07:44 GMT pokassov 2015-06-15T10:07:44Z Adding values if no data is available https://community.qlik.com/t5/QlikView/Adding-values-if-no-data-is-available/m-p/886038#M998297 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I need quick help on this. I have a sales target for sales users. If any users has joined post in the years I.e. in the month of May then the data will not be available from Jan to March. But still when I want to show user target in the pivot table then it should start from Jan rather from May.</P><P></P><P></P><P>Thanks in advance.</P><P>Regards,</P><P>IK</P></BODY></HTML> Sat, 13 Jun 2015 18:45:05 GMT https://community.qlik.com/t5/QlikView/Adding-values-if-no-data-is-available/m-p/886038#M998297 2015-06-13T18:45:05Z Re: Adding values if no data is available https://community.qlik.com/t5/QlikView/Adding-values-if-no-data-is-available/m-p/886039#M998298 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>It depends on your model. If you have table with plans and facts then you already have data values for Jun-Apr.</P><P>If you keep plans in the different table then you can put some "zero" rows into your sale table.</P><P></P><P>Can you attach your model?</P></BODY></HTML> Mon, 15 Jun 2015 10:07:44 GMT https://community.qlik.com/t5/QlikView/Adding-values-if-no-data-is-available/m-p/886039#M998298 pokassov 2015-06-15T10:07:44Z Re: Adding values if no data is available https://community.qlik.com/t5/QlikView/Adding-values-if-no-data-is-available/m-p/886040#M998299 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You can concatenate the Month, users, 0 as Sales with your fact table.</P><P></P><P>Hope it helps.</P></BODY></HTML> Mon, 15 Jun 2015 11:00:13 GMT https://community.qlik.com/t5/QlikView/Adding-values-if-no-data-is-available/m-p/886040#M998299 MayilVahanan 2015-06-15T11:00:13Z