Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
vaibhavb
Contributor
Contributor

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

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.

Labels (4)
1 Reply
Brett_Bleess
Employee
Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.