topic Re: Variable in App Development

Variable

upaliwije — Fri, 02 Apr 2021 07:50:57 GMT

Hi Friends

I have created a variable to be used in my expression but it does not work. Kindly help me to get it corrected

Re: Variable

Shubham_Deshmukh — Wed, 06 Mar 2019 05:19:03 GMT

Hi @upaliwije,

1. It is not good practice to put such hard code values of month year

2. If you want so, no need to use variable for that

3. Try this

=count(DISTINCT(if(match(CHARGED_Month_Year,'Aug-2018','Sep-2018',,,,,),CLAIM_NO)))

Re: Variable

upaliwije — Wed, 06 Mar 2019 05:28:17 GMT

Thanks

Since I have to use this variable over & over again I thought of creating a variable

Re: Variable

Shubham_Deshmukh — Wed, 06 Mar 2019 05:29:37 GMT

If it works for you, mark the answer as solution so that people can get quick idea

Re: Variable

upaliwije — Wed, 06 Mar 2019 05:38:07 GMT

What you suggest works. In fact my previous expression shown in my image also works fine . But What I want to use the expression with a variable for the months mentioned. If you can pls help me with that. Thanks

Re: Variable

MindaugasBacius — Wed, 06 Mar 2019 06:56:21 GMT

Try modifying the expression like this:
Count(Distinct {<CHARGED_month_year = { '$( =$(vCM) )'} CLAIM_NO)

Re: Variable

Shubham_Deshmukh — Wed, 06 Mar 2019 07:05:28 GMT

Hi,

First load you month-year data as it is fix,

dates:
LOAD * INLINE [
monthYear
Aug-18

Sep-18

Dec-18

];

monthYearCombo:
load Concat( chr(39) & monthYear& chr(39), ',') as monthYearCombo
Resident dates;

Let vStatus=monthYearCombo;

Now in expression use this,

=count(DISTINCT(if(WildMatch(CHANGED_Month_Year,'*$(vStatus)*'),CLAIM_NO)))

Re: Variable

Shubham_Deshmukh — Wed, 06 Mar 2019 07:07:10 GMT

I updated ans little bit check this now.

Re: Variable

anushree1 — Wed, 06 Mar 2019 07:38:45 GMT

remove Charged_Month_Year from variable definition keep it as : ={'Aug-2018',.......}

Re: Variable

upaliwije — Wed, 06 Mar 2019 07:41:01 GMT

Thanks

Still it is not working

Re: Variable

anushree1 — Wed, 06 Mar 2019 07:41:48 GMT

can you share the sample file

Re: Variable

upaliwije — Wed, 06 Mar 2019 08:10:23 GMT

Yes That I have already done still not working. My new variable is

Re: Variable

pradosh_thakur — Wed, 06 Mar 2019 08:10:30 GMT

Try this may be ,WHERE vCM is the variable you originally posted

count(distinct{<$(vCM)>}CLAIM_NO)

Re: Variable

upaliwije — Wed, 06 Mar 2019 08:46:24 GMT

This my QV doc with sample data. Pls help me

Re: Variable

upaliwije — Wed, 06 Mar 2019 08:46:35 GMT

This my QV doc with sample data. Pls help me

Re: Variable

Shubham_Deshmukh — Wed, 06 Mar 2019 08:54:13 GMT

It is working in my app, please check once,

Re: Variable

upaliwije — Wed, 06 Mar 2019 08:59:07 GMT

can you pls have a look at my sample data and give me a solution

Re: Variable

Shubham_Deshmukh — Wed, 06 Mar 2019 09:00:30 GMT

Sorry, m unable to open that qvw in my local

Re: Variable

anushree1 — Wed, 06 Mar 2019 10:11:50 GMT

please check the attached I added a new Expression called Using Variable New Expression in the chart using Variable and removed equals from variable definition

Re: Variable

upaliwije — Wed, 06 Mar 2019 10:32:25 GMT

Thanks Dear