Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Help required

Hi,

I have data like this 

sCustomerIdbinTotal WeightDate
100004BLACK016/01/2019
100004BLACK116/01/2019
100004GREEN016/01/2019
100020BLACK14.514/01/2019
100020BLACK014/01/2019
100030GREEN6.521/01/2019
100038BLACK31.515/01/2019
100038GREEN9.522/01/2019
100040BLACK016/01/2019
100040GREEN21.523/01/2019
100050BLACK37.518/01/2019
100050GREEN1825/01/2019
100051GREEN8.524/01/2019
100052BLACK3715/01/2019

 

I need the formula to filter.

Requrement is  for each day if the customerid's each bin is 0 i need that record if not i have to delete that record.if it dont havce other then zero i have to save that record in to excel. can any one hepl in this.

 

Example: for custid 100004 bin is black and weaight is 0 for the day 16 for first record and second record i have same date and same bin and some weaight so i have to delete that 2 records.

other example:100004 has green bin in the same day with 0 weight and there is no othere record for that same day and same bin.so i have to save that record.

for each day each bin each customer id with 0 weights

expected out put:

sCustomerIdbinTotal WeightDate
100004GREEN016/01/2019

 

Can you please help me out.

Thanks and regards,

Vinod.

Labels (1)
0 Replies