If consecutive three months’ data is zero then hide the entire row, each Columns is separated expression, Please find the attached screen shot. Which is highlighted by yellow color.
@munnareddy Is this for Qlik Sense or Qlikview? I would like to move this into the correct product forum.
Please find the sample application and some scenarios also i am attaching for more understanding.
Scenario 1 : the below which i have highlighted this product should removed in this scenario , if they selected from JAN-2017 to AUG-2017 then this product should be appear.means after value we should consider consecutive three months is zero then remove the SKUs.
Scenario 2: here also i have highlighted yellow color
Why don't you use MonthYear as a pivoted dimension in your chart instead of adding so many expressions? If you do this using dimension, it would be much easier to handle this request.
I have tried that is also but it is not working, i am assuming we need to create the flag and count the consecutive three months is zero then we have to remove the entire row which is based on selection period.
In your screenshot you highlighed ARENA180MW, but not ARENA180BK... would ARENA180BK stay or would that be removed too? If it stays, why would it stay? I see 0s from Apr2017 till Oct2017?