topic How to exclude un completed month? in QlikView

How to exclude un completed month?

ramcena306 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Developers ,

I have a straight table, where i have to show avg of last 12 months stock values.

Expression : =$(v_KPI_Stock_24M_Precalc)/ if (Fiscal_Year=VScript_24MStock_FYo,v_NumMonths_CurrentFY,12)

In my project Fiscal Year Starts from October.

If the user want to see 2017 Data, Fiscal Year starts from 2016 Oct . It's all fine.

The Problem Is if we want 2018 data it should show from 2017 oct to 2018 Feb. But Its showing data upto March . I want to exclude Un completed month. How can i write expression.

Please help., stalwar1‌, sureshqv‌, loveisfail‌nagarjuna123‌timanshu‌

Re: How to exclude un completed month?

ramcena306 — Wed, 14 Mar 2018 04:28:12 GMT

Hi Everyone, Please replay!

Re: How to exclude un completed month?

jonathandienst — Wed, 14 Mar 2018 04:39:36 GMT

Do you have a month field? How do you define "uncompleted" - on a calendar or by last update?

Its much harder to debug and suggest solutions for an expression using variables. I suggest that you get the expression working with literal values; once you have a working baseline, then you can consider using variables if needed.