topic Re: QV Expression with set modifier in QlikView

QV Expression with set modifier

Anonymous — Mon, 07 Dec 2015 15:37:10 GMT

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.

Re: QV Expression with set modifier

sunny_talwar — Mon, 07 Dec 2015 15:43:28 GMT

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

Re: QV Expression with set modifier

sfatoux72 — Mon, 07 Dec 2015 15:46:30 GMT

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'}

Re: QV Expression with set modifier

Anonymous — Mon, 07 Dec 2015 15:53:52 GMT

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.

Re: QV Expression with set modifier

Kushal_Chawda — Mon, 07 Dec 2015 15:54:58 GMT

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

Re: QV Expression with set modifier

Anonymous — Mon, 07 Dec 2015 15:55:54 GMT

Thanks Kush for your input

Re: QV Expression with set modifier

Kushal_Chawda — Mon, 07 Dec 2015 15:59:23 GMT

ok, you already done it. I am late

Re: QV Expression with set modifier

Anonymous — Mon, 07 Dec 2015 20:48:00 GMT

Thanks Sebastien for your input, most appreciated

Re: QV Expression with set modifier

Peter_Cammaert — Mon, 07 Dec 2015 21:08:16 GMT

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...

Re: QV Expression with set modifier

Anonymous — Mon, 07 Dec 2015 21:55:20 GMT

Many thanks Peter, Sebastien should be right.