topic Expression for Button in QlikView

Expression for Button

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need to create a button that selects just the last 6 months. I'm not sure of the correct expression to use. Thank you in advance for your help!

Re: Expression for Button

sunny_talwar — Fri, 22 Apr 2016 14:30:22 GMT

Try the attached

Re: Expression for Button

Fri, 22 Apr 2016 15:54:45 GMT

It's not working. I added a table to this attachment which might make it easier. Thank you!

Re: Expression for Button

sunny_talwar — Fri, 22 Apr 2016 16:18:33 GMT

Is it working now?

Created a new field called FiscalDate using Binary Load. You can just create that in your Downtime table using MakeDate function

Date(MakeDate(FiscalYear, Pick(PrdNo, 4, 5, 6, 7, 8, 9, 10, 11, 12, 1, 2, 3), 1)) as FiscalDate

Re: Expression for Button

Fri, 22 Apr 2016 17:58:06 GMT

Thanks for the hard work, but it's giving me Sep, Oct, Nov, Dec, Mar & Apr.

Re: Expression for Button

sunny_talwar — Fri, 22 Apr 2016 18:01:52 GMT

What are you looking for? What's the last 6 months you would expect?

Re: Expression for Button

Fri, 22 Apr 2016 18:11:06 GMT

It's missing Jan & Feb

Re: Expression for Button

sunny_talwar — Fri, 22 Apr 2016 18:17:00 GMT

I am not sure what you goal is. The Fiscal date doesn't have values for some of the PrdNo

I guess when I press the button, it selects everything between Oct 1st and Apr 1st. Now the table you included, includes a Month field. I am not sure how Month is related to PrdNo. But it seems they are not one to one

This seems more like a data modeling issue to me

Re: Expression for Button

Fri, 22 Apr 2016 18:22:12 GMT

It's using "Mth", not "Month" - Sorry for the confusion.

Re: Expression for Button

sunny_talwar — Fri, 22 Apr 2016 18:27:09 GMT

I mean this table

And coming back to the issue again then, we don't have Jan, Feb, Mar. So we only see Oct, Nov, Dec, Apr