topic Re: Variable with parameter in Set Analysis in QlikView

Variable with parameter in Set Analysis

mavericklee — Wed, 18 Jul 2018 17:04:21 GMT

Hi Gurus,

I am now writing a variable as the expression for the dashborard that containg parameter as the set analysis modifier.:

sum({<CalendarDate={">=$(vCurrentMinDate) <=$(vCurrentMaxDate)"},CalendarWeekDay={Fri},$1>}Amount)

while the $1 is another variable "vFirstPeriod" equal to this:

=if(vType=2,

'MonthYear={"$(=$(vCurrentFirstMonth))"}'

,'CalendarWeek={"$(=$(vPeriodWeek($(vCurrentMinDate), $(vCurrentMinDateFirstWeekEnd))))"}'

)

So the final expression appears in the table is like this:

=$(vtest1($(vFirstPeriod)))

The result is that the expression can be evaluated but coming with a wrong result.

The reason is the first parameter cannot be evaluated.

Would anyone suggest the correct syntax for that?

Thanks.

Re: Variable with parameter in Set Analysis

marcus_sommer — Thu, 19 Jul 2018 11:39:05 GMT

I don't want to say that's not possible to get such a construct to work but I think that your nesting of variables which also contain nested variables is an overuse of variables respectively the idea behind them - which is mainly to simplify things.

In my opinion are the efforts to develop and maintain here a stable solution much higher as the benefit (and there is always a risk that you couldn't include all needed functionalities or parameters).

Therefore I suggest to rethink your whole approach. Nevertheless if you want to continue with your approach you will find here multiple postings to this topic:

https://community.qlik.com/search.jspa?q=variable+parameter+comma+marcus

- Marcus