topic Re: Help with set expression - Count only if Aggr is in range ? in QlikView

Help with set expression - Count only if Aggr is in range ?

stockisteven — Fri, 15 Dec 2017 22:41:21 GMT

I am trying to create a set expression where it calculates only Names that have an Aggr count within a range

For example below - If I only wanted to calculate a measure for names to which only have a total count value of > 4, then only Steve would be included.

What am I doing wrong ? Thanks !!

Steven(5) Sean(3)

H1234 E9384

H5678 E9393

H6656 E334

H9989

H9445

Re: Help with set expression - Count only if Aggr is in range ?

vishsaggi — Sat, 16 Dec 2017 01:29:35 GMT

Can you share your qvf file to look into?

Re: Help with set expression - Count only if Aggr is in range ?

Anil_Babu_Samineni — Sat, 16 Dec 2017 04:08:29 GMT

What you shown in image wrong.. But, Try to explain your needed

Re: Help with set expression - Count only if Aggr is in range ?

sunny_talwar — Sat, 16 Dec 2017 12:57:25 GMT

May be this

Count({1<[PCP Full Name] = {"=Count(PCPanel) > 2000"}>}PVPanel)

Re: Help with set expression - Count only if Aggr is in range ?

stockisteven — Sat, 16 Dec 2017 23:39:11 GMT

Hi Sunny,

Appreciate the response - but that only works on the selection.

I want this expression to look at all the names - irregardless of the current selection.

I'm think the aggr function needs to be involved.

Re: Help with set expression - Count only if Aggr is in range ?

vishsaggi — Sun, 17 Dec 2017 17:40:33 GMT

Extending Sunny's expression may be you can try like below?

= Count({1<[PCP Full Name] = P({< [PCP Full Name] = {"=Count(PCPanel) > 2000"} >} [PCP Full Name]) >} PVPanel)

Re: Help with set expression - Count only if Aggr is in range ?

sunny_talwar — Sun, 17 Dec 2017 22:20:40 GMT

May be, but don't really have enough information to know what you have and what you might need... would you be able to share a sample?