topic Re: using functions within set analysis in QlikView

using functions within set analysis

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

In set analysis, can I use function to specify criteria? For example, I have date field available and I want to add up the current year data

Can I do something like sum({<YearName(date)= YearName{'$(=vCurrentCMonthYear)'}>}Amount)

Seems like it does not work as there probably different syntax I shoulde use for YearName(date)?

prma7799 — Tue, 26 Sep 2017 06:30:50 GMT

Try like this

=Sum({<[Posting Date] = {"=YearName(Today())"}>}[Amount])

What is your value in vCurrentCMonthYear

its_anandrjs — Tue, 26 Sep 2017 06:32:11 GMT

No not this ways what is the value in vCurrentCMonthYear

Anil_Babu_Samineni — Tue, 26 Sep 2017 06:33:57 GMT

No, You can't as Qlik has limit of left part of equal symbol not entry with calculated

You can try That in script like YearName(date) as date_set

then call it as

sum({<date_set= {'$(=YearName(vCurrentCMonthYear))'}>}Amount)

You can play with variable if equal / single quote issues ..

ronaldwang — Tue, 26 Sep 2017 06:37:38 GMT

thanks, that is what I want to confirm before going to the variable part

ronaldwang — Tue, 26 Sep 2017 06:38:41 GMT

is the current month and year like Sep-2017

its_anandrjs — Tue, 26 Sep 2017 06:42:59 GMT

You can do this with the NumMonth and Year field also which is dynamic to you also.

=Sum({<YearField = {"$(=Max(YearField))"}, NumMonth={"$(=Max(NumMonth))"}>} Amount)