topic Re: Set Analysis with function of Year(today()) in QlikView

Set Analysis with function of Year(today())

Anonymous — Fri, 02 Dec 2016 07:13:21 GMT

hi..Can you anybody please help me with the below expression. I have used set analysis and dont know what is going wrong with the syntax when I use year(today()) in it. I need to find out the count resolved tickets for current year. When I use the below expressions it shows 0

=count({<[Resolved Year] ={"&(=year(today()))"}>}[TR #])

Re: Set Analysis with function of Year(today())

tresB — Fri, 02 Dec 2016 07:26:10 GMT

How are the values in your field [Resolved Year]? Simple numbers like 2015, 2016 .. or 15-16..?

Re: Set Analysis with function of Year(today())

swuehl — Fri, 02 Dec 2016 07:34:05 GMT

Try

=count({<[Resolved Year] ={"$(=year(today()))"}>}[TR #])

Remember, it's called Dollar-Sign expansion,

Re: Set Analysis with function of Year(today())

Anonymous — Fri, 02 Dec 2016 07:34:27 GMT

Simple number like '2016'

Re: Set Analysis with function of Year(today())

tresB — Fri, 02 Dec 2016 07:36:00 GMT

Then replacing '&' with '$' should work (as spotted by Stefan)

Re: Set Analysis with function of Year(today())

Anonymous — Fri, 02 Dec 2016 08:53:37 GMT

Thanks it worked.. when do i use & and $ in the formula? I had used & in getfieldselection with setanalysis in the past

Re: Set Analysis with function of Year(today())

swuehl — Fri, 02 Dec 2016 09:05:06 GMT

Sanjyot Paktar wrote:

Thanks it worked.. when do i use & and $ in the formula? I had used & in getfieldselection with setanalysis in the past

Not sure how this should have worked. Any sample code?

In general, QV script and expression language syntax is defining how you need to write your code.

If in doubt, read the QV reference manual and HELP file, it's more often correct than wrong.

I highly recommend following Henric's blog posts and reading his tech docs, e.g.

The Magic of Dollar Expansions

Re: Set Analysis with function of Year(today())

moojahid2 — Tue, 20 Nov 2018 06:31:48 GMT

Hi,

for test I'm giving Year(Today()), it shows 2.02k. However Today() shows exact date? what is the problem with Year(Today())

Re: Set Analysis with function of Year(today())

Ozturkec — Mon, 25 Feb 2019 11:02:31 GMT

It is not working for Week(today()). could you help about these function but terms of Week?

Thanks!