topic Fetch previous 12 months data from current month selection in QlikView

Fetch previous 12 months data from current month selection

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

Hi All

I am having trouble in fetching the previous 12 months data in the bar chart. I have written the following query:

=count({1}{<M_Month={"<=$(vCurrentSelectionMonth)"},[Action Category]={'Leavers'}>}[Number of Actions])

I want to fetch the previous 12 months data as per my current month selection.

Suppose, I am selecting Oct 2016 month then it should show me data in the bar chart from Nov 2015 to Oct 2016.

PFA images for more details.

Thanks in advance

sunny_talwar — Wed, 08 Feb 2017 16:16:28 GMT

What is your M_Month field format? Also, you have {1} at the incorrect location

=Count({1}{1<M_Month = {"<=$(vCurrentSelectionMonth)"}, [Action Category] = {'Leavers'}>}[Number of Actions])

Anonymous — Thu, 09 Feb 2017 05:32:48 GMT

Format for M_Month is "MMM" ie. Jan, Feb, Mar

sunny_talwar — Thu, 09 Feb 2017 11:18:21 GMT

and how is vCurrentSelectionMonth defined? I would suggest creating a numerical Month field in the script.

Num(M_Month) as Num_M_Month

and use that in your expression