topic Re: Combine IF statement with Variable and Set Analysis in App Development

Combine IF statement with Variable and Set Analysis

hjm35055 — Sat, 16 Nov 2024 00:16:41 GMT

Hi,

I have a pretty large equation and I am trying to control a portion of set analysis with a variable and am not sure if it is possible.

I have a variable: vShowHidePeriod = 1 or 0 depending on the variable input button.

If vShowHidePeriod = 1 then I want 'LMTD_Flag={'1'}' to display in the set analysis, if vShowHidePeriod = 0, then I want 'LMTD_Flag=' to show in the set analysis.

Equation I am trying to accomplish:

Count({<EncounterCategory1-={'Non-Encounter Charges'}, IF($(vShowHidePeriod)=1, 'LMTD_Flag={'1'},', 'LMTD_Flag=,')) >} DISTINCT EncounterUID)

Thanks in advance!

Re: Combine IF statement with Variable and Set Analysis

jwjackso — Fri, 09 Apr 2021 18:28:34 GMT

I've done something similar in Qlikview. Instead of having the button set the variable to 1 or 0, have it set the Set Analysis expression LMTD_Flag = {'1'} or LMTD_Flag=

Then in the expression use the variable, Count({<EncounterCategory1-={'Non-Encounter Charges'},$(vShowHidePeriod)>}Distinct EncounterUID)

Re: Combine IF statement with Variable and Set Analysis

hjm35055 — Fri, 09 Apr 2021 18:36:13 GMT

I thought about that. The problem is, I want this variable to control additional set analysis on this sheet such as MTD_Flag, YTD_Flag, and LYTD_Flag.

I have a sheet of 10+ KPIs and they are currently set to show the current MTD, LMTD, YTD, and LYTD when you open it. I want to create a variable controlled by an ON or OFF button to allow for dynamic date selection. Essentially says to use date flag set analysis or ignore the date flag set analysis.

Re: Combine IF statement with Variable and Set Analysis

JMAROUF — Fri, 09 Apr 2021 19:53:37 GMT

hello @hjm35055

did you tried this?

=if(vShowPeriode=1, count({<EncounterCategory1-={'Non-Encounter Charges'},LMTD_Flag={1}>} DISTINCT ID),
count({<EncounterCategory1-={'Non-Encounter Charges'},LMTD_Flag=>} DISTINCT ID))