topic Assigning Values to NULLs in QlikView https://community.qlik.com/t5/QlikView/Assigning-Values-to-NULLs/m-p/235107#M86396 <HTML><HEAD></HEAD><BODY><P>So I'm building a new QVW and this requirement has given me some trouble.</P><P>We have order numbers that are assigned to countries, but some are NULL. So we want to assign the NULLs to a country based on the percentage of the country over all the tickets.</P><P>For example...</P><P>USA - 50 tickets</P><P>UK - 25 Tickets</P><P>INDIA - 15 Tickets</P><P>JPN - 10 Tickets</P><P>If there are 20 NULL tickets 50% should be assigned to US, 25% to UK, etc...</P><P>Any suggestions?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 27 Jul 2010 15:41:46 GMT 2010-07-27T15:41:46Z Assigning Values to NULLs https://community.qlik.com/t5/QlikView/Assigning-Values-to-NULLs/m-p/235107#M86396 <HTML><HEAD></HEAD><BODY><P>So I'm building a new QVW and this requirement has given me some trouble.</P><P>We have order numbers that are assigned to countries, but some are NULL. So we want to assign the NULLs to a country based on the percentage of the country over all the tickets.</P><P>For example...</P><P>USA - 50 tickets</P><P>UK - 25 Tickets</P><P>INDIA - 15 Tickets</P><P>JPN - 10 Tickets</P><P>If there are 20 NULL tickets 50% should be assigned to US, 25% to UK, etc...</P><P>Any suggestions?</P><P></P><P>Thanks!</P></BODY></HTML> Tue, 27 Jul 2010 15:41:46 GMT https://community.qlik.com/t5/QlikView/Assigning-Values-to-NULLs/m-p/235107#M86396 2010-07-27T15:41:46Z