topic Re: How to deal with non existing data? in QlikView https://community.qlik.com/t5/QlikView/How-to-deal-with-non-existing-data/m-p/1428373#M802097 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 21 Nov 2017 01:56:16 GMT Anil_Babu_Samineni 2017-11-21T01:56:16Z How to deal with non existing data? https://community.qlik.com/t5/QlikView/How-to-deal-with-non-existing-data/m-p/1428372#M802096 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>The data keeps record of the customer statuses within the course of 12 weeks.</P><P></P><P><IMG __jive_id="183956" alt="table1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183956_table1.png" style="height: auto;" /></P><P></P><P>I am asked to create a new status called "Still Selected" that will ideally tell us whether there has been a status for a particular week.</P><P></P><P>For example, accountno 9626665 has 2 records for week 6 and the other one week 9. So, for weeks 1, 2, 3, 4,5,7,8,10, and 11 there has been no primary status, therefor no records. The goal is to create a new status Still Selected which will be 1 when there is no status in a week and 0 when at least one status exist in that week.</P><P></P><P></P><P><IMG __jive_id="183957" alt="table2.png" class="jive-image image-2" height="191" src="https://community.qlik.com/legacyfs/online/183957_table2.png" style="height: 191.497px; width: 776px;" width="776" /></P><P></P><P>The challenge is I don't know how to set a condition to assess whether there is any status for each week when there is no records for some of the weeks!</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-deal-with-non-existing-data/m-p/1428372#M802096 Anonymous 2020-11-25T16:16:04Z Re: How to deal with non existing data? https://community.qlik.com/t5/QlikView/How-to-deal-with-non-existing-data/m-p/1428373#M802097 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Tue, 21 Nov 2017 01:56:16 GMT https://community.qlik.com/t5/QlikView/How-to-deal-with-non-existing-data/m-p/1428373#M802097 Anil_Babu_Samineni 2017-11-21T01:56:16Z