QV Expression with set modifier

[Anonymous]

I have the following QV which was working before i added the [Drug Name] set modifier:

if(Rank(Sum({$<MonthDiff={"<12"}>} Amount)) <= 12, Sum({$<MonthDiff={"<12"}, [Drug Name] = {'CALCIGARD (NIFEDIPINE) 20MG SUSTAINED RELEASE TABLETS
'}>} Amount))

On adding the modifier:

[Drug Name] = {'CALCIGARD (NIFEDIPINE) 20MG SUSTAINED RELEASE TABLETS
'}

my graph does not show any results:  No Data to Display

What is wrong with the above expression?

Regards.

[sunny_talwar]

May be you misspelled something in the Drug Name or there are extra spaces between words.

[sfatoux72]

Hello Christopher,

Why is the quote on a new line? Is it like that on your expression?

[Drug Name] = {'CALCIGARD (NIFEDIPINE) 20MG SUSTAINED RELEASE TABLETS

'}

If yes, try like that:

[Drug Name] = {'CALCIGARD (NIFEDIPINE) 20MG SUSTAINED RELEASE TABLETS'}

[Anonymous · Accepted solution]

Thanks Sunny, i changed around where the set modifier is placed as follows:

if(Rank(Sum({$<MonthDiff={"<12"}>} Amount)) <= 12, Sum({$<[Drug Name] = {'CALCIGARD (NIFEDIPINE) 20MG SUSTAINED RELEASE TABLETS'},MonthDiff={"<12"}>} Amount))

and it worked.  There were no changes with the [Drug Name], just cut it from the end and pasted it at the beginning.

[Kushal_Chawda]

Create the List box of Drug Name field in front end

Search the required value to be filter in list box and select the same, then right click on selected value-> Copy to clipboard -> Cell Value

Paste the value in Set analysis

[Anonymous]

Thanks Kush for your input

[Kushal_Chawda]

ok, you already done it. I am late

[Anonymous]

Thanks Sebastien for your input, most appreciated

[Peter_Cammaert]

Are you sure that you didn't at the same time remove the included newline character, as Sébastien suggested? If not, we have here a major anomaly in set definitions where set modifiers suddenly became position-dependent...

[Anonymous]

Many thanks Peter, Sebastien should be right.