topic Re: Set analysis using Month Function as operator in QlikView

Set analysis using Month Function as operator

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

Trying to make the iPlanMonth#, Month#, and Fiscal Year select only what is current month/Year. Example I only want to to pull the values from the Forecasted version 10(oct) where the Month is 10(oct) and only for 2017.

SUM({1<iPlanMonth#={'=Month(Today())'},Month#={'=Month(Today())'},[Fiscal year]={'=Year(Today())'}>}[Metric Tons])

Re: Set analysis using Month Function as operator

Anonymous — Thu, 05 Oct 2017 14:01:47 GMT

below worked but I cannot get same results for to grab the Min selected date for iPlanMonth#

Current month forecast sum:

SUM({<iPlanMonth# = {$(=Max(num(iPlanMonth#)))},[Data Source]={'Forecast'},[Fiscal year] = {$(=num(Year(Today())))}>}[Metric Tons])

Thanks,

SUM({<iPlanMonth# = {$(=Min(num(iPlanMonth#)))},[Data Source]={'Forecast'},[Fiscal year] = {$(=num(Year(Today())))}>}[Metric Tons])

Re: Set analysis using Month Function as operator

its_anandrjs — Thu, 05 Oct 2017 16:23:06 GMT

This way try with commas

SUM({<iPlanMonth# = { "$(=Max(num(iPlanMonth#)))" }, [Data Source] = {'Forecast'} , [Fiscal year] = {"$(=num(Year(Today())))" }>}[Metric Tons])

Re: Set analysis using Month Function as operator

Anonymous — Thu, 05 Oct 2017 16:28:32 GMT

Thanks that worked to get the Current Month forecast, but I cant seem to get it to work to get the previous months. Is there a way to take the min iPlanMonth# based on the selection?

Re: Set analysis using Month Function as operator

dinuwanbr — Fri, 06 Oct 2017 06:51:41 GMT

Hi,

Can you upload a sample here?

Rgds,

Tharindu