topic Re: year formula dose not worke in App Development

year formula dose not worke

Alonal148 — Thu, 13 Feb 2020 10:35:41 GMT

Hi,

Need help to understand why the next formula dose not work:

={<[diffDate.autoCalendar.Year]={'2018'}>}

I would like to show only year 2018 in a table.

Thank you,

Alona

Re: year formula dose not worke

tresB — Thu, 13 Feb 2020 10:41:14 GMT

Could you explain with more detail? What is the entire expression? Where are you using it?

Re: year formula dose not worke

sunny_talwar — Thu, 13 Feb 2020 12:36:52 GMT

How is your derived calendar coding Year field? Is this the code that is getting used? -> Year($1) As Year Tagged ('$numeric') or is it doing something else?

Calendar: DECLARE FIELD DEFINITION TAGGED '$date' Parameters first_month_of_year = 1 Fields Year($1) As Year Tagged ('$numeric'), Month($1) as Month Tagged ('$numeric'), Date($1) as Date Tagged ('$date'), Week($1) as Week Tagged ('$numeric'), Weekday($1) as Weekday Tagged ('$numeric'), DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric');

Re: year formula dose not worke

Alonal148 — Sun, 16 Feb 2020 06:56:04 GMT

Hi,

I tried to limit table to year 2018.

And I want the dimansion "year" will apper in the rows.

Thank you

Re: year formula dose not worke

Alonal148 — Sun, 16 Feb 2020 07:03:55 GMT

Hi,

In the base table there is only 'Date'.

The 'Year' was created by Qlik automatic.

Re: year formula dose not worke

Alonal148 — Sun, 16 Feb 2020 07:45:34 GMT

Hi,

I sloved the problem.

The expresuin should be on tyhe measure:

Avg({$<[diffDate.autoCalendar.Year]={'2018'}>}([sales]))

Thank tou

Re: year formula dose not worke

sunny_talwar — Tue, 18 Feb 2020 12:09:17 GMT

Right, and how exactly is this Qlik automatic script look like?

Re: year formula dose not worke

Alonal148 — Thu, 20 Feb 2020 12:34:23 GMT

Thank you.

I sloved the problem