topic Re: Setting conditional expression using Today() in QlikView

Setting conditional expression using Today()

ZoeM — Mon, 03 Dec 2018 17:42:31 GMT

Hi Community.

I have a chart with 6 expressions and I would like to set one expression to only calculate on a condition that the selected Year in the List box equals current year. If the selected year is either greater than or less current year, then it wont calculate.

My conditional expression:

GetCurrentSelections(Year)= Date(Today(),'YYYY')

But I am not getting any results.

any help with getting the right syntax for the expression will be truly appreciated.

Re: Setting conditional expression using Today()

sunny_talwar — Mon, 03 Dec 2018 17:47:26 GMT

I am guessing that you year field is created like this in the script

Year(DateField) as Year

May be try this

GetCurrentSelections(Year) = Year(Today())

Re: Setting conditional expression using Today()

ZoeM — Mon, 03 Dec 2018 17:54:16 GMT

Thanks for responding,

No, my year is not set up that way in the script.

I tried your suggestion but I got no results...

Re: Setting conditional expression using Today()

sunny_talwar — Mon, 03 Dec 2018 18:01:04 GMT

How do you create a year field in the script?

Re: Setting conditional expression using Today()

ZoeM — Mon, 03 Dec 2018 18:05:06 GMT

I have a Date Key which works with the Master Calendar.

Re: Setting conditional expression using Today()

sunny_talwar — Mon, 03 Dec 2018 18:08:13 GMT

Make sense, but how is Year field created?

Re: Setting conditional expression using Today()

ZoeM — Mon, 03 Dec 2018 18:18:00 GMT

Below are my date fields:

LOAD %Date,
Date,
Year,
[Quarter Number],
[Quarter Name],
[Month of Year],
[Month of Year Name],
[Month of Year Abbreviated Name],
[Week of Year],
[Day of Week],
[Day of Week Name],
[Day of Week Abbreviated Name],
[Day of Month],
[Day of Year],
[Days in Month],
Date(MonthStart(Date),'MMM YY') as YearMonth,
[Leap Year Flag],
[Weekend Flag],
[Production Month],
[Production Year],
[Issue Number],
[Julian Date],
[Week Ending Friday]

Re: Setting conditional expression using Today()

sunny_talwar — Mon, 03 Dec 2018 18:21:16 GMT

Can you try this

LOAD %Date,
Date,
Year(Date) as Year,
[Quarter Number],
[Quarter Name],

and then this

GetCurrentSelections(Year) = Year(Today())

Re: Setting conditional expression using Today()

ZoeM — Mon, 03 Dec 2018 18:29:57 GMT

Still I get nothing. It should be GetCurrentSelections right?

Re: Setting conditional expression using Today()

sunny_talwar — Mon, 03 Dec 2018 18:35:30 GMT

Hahahaha, you are right... you should be using GetFieldSelections(Year) instead of GetCurrentSelections 🙂

Re: Setting conditional expression using Today()

ZoeM — Mon, 03 Dec 2018 18:37:20 GMT

Thanks so much, works like a charm now!