topic Re: How to fill empty values in QlikView https://community.qlik.com/t5/QlikView/How-to-fill-empty-values/m-p/545453#M203726 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you attached sample app here, so that we can figure it out together.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Sat, 06 Jul 2013 04:45:38 GMT Sokkorn 2013-07-06T04:45:38Z How to fill empty values https://community.qlik.com/t5/QlikView/How-to-fill-empty-values/m-p/545452#M203725 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to analyze the sales of 20 hotel during the las 30 months so I made a table with three fields (month, year, hotel) resulting 600 rows, obviously.</P><P></P><P>Then I made a join of the sales table (month, year, hotel, salesamount) but I 'loose' rows, because not all the hotels were open in a specific month so they have no row for that month-year-hotel. </P><P></P><P>If there is no sales value for a specific month-year-hotel I would need a '0' as saleamount instead of a dissapeared row.</P><P></P><P>How to get this?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 05 Jul 2013 18:29:53 GMT https://community.qlik.com/t5/QlikView/How-to-fill-empty-values/m-p/545452#M203725 2013-07-05T18:29:53Z Re: How to fill empty values https://community.qlik.com/t5/QlikView/How-to-fill-empty-values/m-p/545453#M203726 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you attached sample app here, so that we can figure it out together.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Sat, 06 Jul 2013 04:45:38 GMT https://community.qlik.com/t5/QlikView/How-to-fill-empty-values/m-p/545453#M203726 Sokkorn 2013-07-06T04:45:38Z