topic Re: Hide the Entire rows based on consecutive three months zeros in QlikView

Hide the Entire rows based on consecutive three months zeros

Srinivas — Sat, 16 Nov 2024 20:53:19 GMT

Hi Team,

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.

Thanks,

Munna

Re: Hide the Entire rows based on consecutive three months zeros

Sue_Macaluso — Mon, 13 May 2019 10:33:14 GMT

@Srinivas Is this for Qlik Sense or Qlikview? I would like to move this into the correct product forum.

Re: Hide the Entire rows based on consecutive three months zeros

Srinivas — Mon, 13 May 2019 11:35:54 GMT

Hi Macaluso,

I am looking for Qlikview side.

Thanks,

Srinivas

Re: Hide the Entire rows based on consecutive three months zeros

sunny_talwar — Mon, 13 May 2019 11:37:59 GMT

Would you be able to share a qvw sample to look at what you have and try out few possibilities?

Re: Hide the Entire rows based on consecutive three months zeros

Srinivas — Tue, 14 May 2019 08:08:41 GMT

Hi Sunny,

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

Thanks,

Srinivas

Re: Hide the Entire rows based on consecutive three months zeros

sunny_talwar — Tue, 14 May 2019 11:03:38 GMT

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.

Re: Hide the Entire rows based on consecutive three months zeros

Srinivas — Tue, 14 May 2019 12:38:59 GMT

Hi Sunny,

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.

Thanks,

Srinivas

Re: Hide the Entire rows based on consecutive three months zeros

Srinivas — Thu, 16 May 2019 08:09:57 GMT

Hi Sunny,
Please suggest me the above issue.
Thanks,
Srinivas

Re: Hide the Entire rows based on consecutive three months zeros

sunny_talwar — Thu, 16 May 2019 12:46:37 GMT

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?

Re: Hide the Entire rows based on consecutive three months zeros

Srinivas — Fri, 17 May 2019 03:15:26 GMT

Thanks Sunny,
ARENA180BK this SKU should stay why because Nov-2017 month have the value.
Here logic is from max month to last three months continuously data is zero then we need to hide the row, this selection period also as per mind set it will change.
So we should hide these rows ARENA180MW,ARENA 180 BLANC,ARENA180BLK,ARENA180BK -Z,ARENA180WH.
We should not hide the ARENA180BK only.

Please let me know if need more clarity.

Thanks,
Srinivas