topic Re: Month restriction based on Bucket selection in QlikView

Month restriction based on Bucket selection

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

Hi All,

I am having 2 fields (Fore Cast Month,Bucket). Here I need to show the month & For Cast Values in the chart based on selections of Fore Cast & Bucket

For Ex If I select "Jan 2017" in Fore Cast Month and "3+Months" in the Bucket I need to show the values starting from Jan 2017 to Mar 2017. Same way if I select May 2017 and 6+ Months the chart should show the Fore Cast values from May 2017 to Oct 2017.

Please let me know if there is query

-Jai

Re: Month restriction based on Bucket selection

Anonymous — Fri, 12 May 2017 05:53:02 GMT

++ Atatchment

Re: Month restriction based on Bucket selection

tyagishaila — Fri, 12 May 2017 06:53:54 GMT

yes you can do it by using addmonths()

=If(Bucket='3+Months', Date(Addmonths(MonthStart(Date(Date#([Fore Cast Month],'MMM YYYY')) ),3),'MMM YYYY'))

Re: Month restriction based on Bucket selection

Anonymous — Fri, 12 May 2017 08:34:22 GMT

Hi Shaila,

I am not getting the expected result. Could you help me on this?

-Jai

Re: Month restriction based on Bucket selection

Anonymous — Fri, 12 May 2017 10:29:43 GMT

Hi All,

Any idea on the above?

- Jai

Re: Month restriction based on Bucket selection

tyagishaila — Fri, 12 May 2017 10:38:00 GMT

Share qvw sample.

Re: Month restriction based on Bucket selection

Anonymous — Fri, 12 May 2017 10:52:13 GMT

++ QVW

Re: Month restriction based on Bucket selection

ElizaF — Fri, 12 May 2017 11:44:58 GMT

Hi,

See another solution in attach file. I used Set Analysis function and I thing it cover your request.

Another solution is to use AsOfTable Concept.

I do not recommend the above function because it is consuming resources in the UI.

Re: Month restriction based on Bucket selection

Frank_Hartmann — Fri, 12 May 2017 12:12:10 GMT

See attached file.

hope this helps