topic Re: Set Analysis in a variable in QlikView

Set Analysis in a variable

fcecconi — Tue, 13 Jun 2017 17:24:59 GMT

Hello

I have a variable created using the following count(Distinct {$<CD_Flag={1}, RecoveryType={'InPatient'}, Adjustment_Flag={0}, RecordType={'Billing'}, Billing_Type_Flag={1}>} DistinctPatient)

It works some time and some time is give the wrong value. If I cut and paste the actual logic into the expression it returns the correct value all the time.

Any thoughts?

thanks

Frank

Re: Set Analysis in a variable

sunny_talwar — Tue, 13 Jun 2017 17:36:37 GMT

Are you using this with or without the equal sign?

The Little Equals Sign

The Magic of Variables

Re: Set Analysis in a variable

fcecconi — Tue, 13 Jun 2017 17:58:45 GMT

Sunny

the variable is defined in an excel spreadsheet and doesn't have the = sign.

and in the express I am using $(vTotalDays_Inpatient_Curr_Day_Billing)

Re: Set Analysis in a variable

sunny_talwar — Tue, 13 Jun 2017 18:13:31 GMT

One way to check would be to remove the label and see if you see the same expression for when you use the expression vs when you use variable. Variable is essentially used to replace the expression, so when used, variable is expanded into the expression which gives the final result. If it shows the same expression... then there is no way it could give different output.

Re: Set Analysis in a variable

fcecconi — Wed, 14 Jun 2017 13:22:56 GMT

Sunny

It has something to do with my if statement. I replaced the variables with the logic and got the same result. if i just enter the variable or logic without the if, I get the right result.

if(WeekDay($(vToday)) <> 'Sun', $(vTotalDays_Inpatient_Curr_Day_Billing), $(vTotalDays_Inpatient_Rolling3_Billing))

Re: Set Analysis in a variable

sunny_talwar — Wed, 14 Jun 2017 13:24:58 GMT

What is vToday?

Re: Set Analysis in a variable

fcecconi — Wed, 14 Jun 2017 13:30:54 GMT

Sunny

We found the issue. It appears that the function WeekDay($(vToday)) is not always evaluating. We have replaced this with a variable the contains the same logic and now we are getting the correct results.

thanks for leading us in the right directions.