Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ramcena306
Contributor

How to exclude un completed month?

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‌, loveisfailnagarjuna123timanshu

2 Replies
ramcena306
Contributor

Re: How to exclude un completed month?

Hi  Everyone, Please replay!

MVP
MVP

Re: How to exclude un completed month?

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.

Community Browser