How to pass parameter to variable/function which include multiple comma .

vaibhavb — Sat, 16 Nov 2024 18:52:57 GMT

Here, p_NumberFormatter is varaible/function for amount formatting which accepts only single input as $1 and

p_sumOne and p_sumTwo is parameter.

Explained below :-

p_NumberFormatter : Money($1/CONVERSIONFACTOR, $(=chr(39) & CURRENCYFORMAT & chr(39)))

p_sumOne : Sum(DAYSCLOSINGBALANCE)

p_sumTwo : Sum({$<GENERALLEDGERTYPEDTL = {'OPR'},GENERALLEDGERLEVEL1={2},GENERALLEDGERLEVEL2 = {3}, CONSIDERTRANSACTION = {'YES'}>}DAYSCLOSINGBALANCE)

$(p_NumberFormatter($(p_sumOne))) -- Working Fine with p_NumberFormatter

$(p_NumberFormatter($(p_sumTwo)) -- Not Working because expression contains one or more ',' (comma).

$(p_NumberFormatter($(=$(p_sumTwo))) -- Working but getting same value in the trend for each fiscal year.

Re: How to pass parameter to variable/function which include multiple comma .

Brett_Bleess — Tue, 21 Apr 2020 18:15:23 GMT

Doubt you are going to get any responses without an example QVW file on this one so folks can see exactly what you are doing and how.

Regards,
Brett

topic How to pass parameter to variable/function which include multiple comma . in QlikView

How to pass parameter to variable/function which include multiple comma .

Re: How to pass parameter to variable/function which include multiple comma .