topic Re: Sum a set not equal to in QlikView

Sum a set not equal to

tinkerz1 — Mon, 22 Jun 2015 12:14:38 GMT

Hi,

I am trying to use the following example to sum everything when in a set [ABC] that does no contain *Threshold*

Re: Not equal to in set analysis

Any help please...my 3 variants are not working, the last two are from the above example

Sum({[OHRL]<[ABC]<>{'*Threshold*'}, Group=OHRL::Group>}Data)

not equal too

Sum({[OHRL]<[ABC]-={'*Threshold*'}, Group=OHRL::Group>}Data)

not equal to v2
Sum({[OHRL]<[ABC]={"=[ABC] <>'*Threshold*'"}, Group=OHRL::Group>}Data)

Re: Sum a set not equal to

swuehl — Mon, 22 Jun 2015 12:24:16 GMT

First variant is not expected to work.

Variants 2 should / could work. If you think it doesn't, please post some sample data, your expected results and the context you are using these expressions. Best by uploading a small sample QVW.

Variant 3 needs a modification to allow the wildcard usage:

Sum({[OHRL]<[ABC]={"= not ([ABC] like '*Threshold*') "}, Group=OHRL::Group>}Data)

Re: Sum a set not equal to

sunny_talwar — Mon, 22 Jun 2015 12:25:24 GMT

Try this may be:

=Sum({[OHRL]<[ABC] = e({<[ABC] = {'*Threshold*'}>}), Group=OHRL::Group>} Data)

Re: Sum a set not equal to

pratap6699 — Mon, 22 Jun 2015 14:50:06 GMT

use implicit function in set expression E()

=Sum({[OHRL]<[ABC] = E({<[ABC] = {'*Threshold*'}>}), Group=OHRL::Group>} Data)

Re: Sum a set not equal to

ramoncova06 — Mon, 22 Jun 2015 14:54:04 GMT

here goes another option

Sum({[OHRL]<[ABC]={"=index([ABC],'Threshold') < 1 "}, Group=OHRL::Group>}Data)