topic Re: Action in a textbox in QlikView

Action in a textbox

tchovanec — Wed, 23 Oct 2013 15:20:01 GMT

I currently have this expression in a text box. This is giving me the current number I want.

=SUM(AGGR(IF(FirstSortedValue(
{<

ADMIT_DT ={">=$(=NUM(ADDMONTHS(MONTHSTART(MAX(ISLAND_CALENDAR.DATE)),-12)))<=$(=MA(ISLAND_CALENDAR.DATE))"},
FLG_Z_PATIENTS = {0},
ISLAND_DEPT.DEPT_ABBR = P(DEPT_ABBR)

>}
DISTINCT DEPT_ABBR,-ADMIT_DTTM)=ISLAND_DEPT.DEPT_ABBR,1,0),MRN,ISLAND_DEPT.DEPT_ABBR))

I then want to put an action on this text box to select the MRN’s. Here is what I have tried with no luck.

='(' &CONCAT(AGGR(IF(FirstSortedValue(

{<
ADMIT_DT ={">=$(=NUM(ADDMONTHS(MONTHSTART(MAX(ISLAND_CALENDAR.DATE)),-12))) <=$(=MAX(ISLAND_CALENDAR.DATE))"},
FLG_Z_PATIENTS = {0},
ISLAND_DEPT.DEPT_ABBR = P(DEPT_ABBR)
>}
DISTINCT DEPT_ABBR,-ADMIT_DTTM)= ISLAND_DEPT.DEPT_ABBR,1,0),MRN,ISLAND_DEPT.DEPT_ABBR)DISTINCTMRN, '|') & ')'

Can this be done in a text box where I am using the aggr function? Any help would be appreciated. Thank you.

Re: Action in a textbox

preminqlik — Wed, 23 Oct 2013 16:44:35 GMT

HI THERE ,

first you select MRN in list box then create a newbookmark

now create your text box,go to actions > bookmarks>apply book marks>enter book mark ID

Re: Action in a textbox

tchovanec — Wed, 23 Oct 2013 16:55:29 GMT

I cannot select the MRN's in a list box because this is all dependent on the number in the text box. If I have 15 in the text box then I want to click the text object and select those 15 MRNs.

Re: Action in a textbox

Gysbert_Wassenaar — Wed, 23 Oct 2013 17:03:31 GMT

Please post a sample document that demonstrates the problem. See this document for how to do that safely: Preparing examples for Upload - Reduction and Data Scrambling

Re: Action in a textbox

Gysbert_Wassenaar — Wed, 23 Oct 2013 18:08:53 GMT

Try this expression for the search string:

='(' & concat(DISTINCT AGGR(IF(FirstSortedValue(

ADMIT_DT ={">= $(=NUM(ADDMONTHS(MONTHSTART(MAX(ISLAND_CALENDAR.DATE)),-12))) <=$(=MAX(ISLAND_CALENDAR.DATE))"},

FLG_Z_PATIENTS = {0},

ISLAND_DEPT.DEPT_ABBR = P(DEPT_ABBR)

DEPT_ABBR,-ADMIT_DTTM)= ISLAND_DEPT.DEPT_ABBR,MRN),MRN,ISLAND_DEPT.DEPT_ABBR),'|') & ')'

Re: Action in a textbox

tchovanec — Wed, 23 Oct 2013 18:12:02 GMT

That was it, I was pretty close. Thank you very much.