Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to deal with non existing data?

Hi Community,

The data keeps record of the customer statuses within the course of 12 weeks.


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.

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.


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!


1 Reply


Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)