topic Re: GetNotSelectedCount function not working in QV12 SR1? in QlikView

GetNotSelectedCount function not working in QV12 SR1?

Kushal_Chawda — Mon, 04 Apr 2016 06:15:04 GMT

Hi All,

I have noticed that GetNotSelectedCount() fucntion in QV 12 SR1 not working properly. Anybody experienced the same? may be I am doing something wrong, but can anyone test the same?

sunindia‌ swuehl‌ Avinashelite‌ jagan‌

Re: GetNotSelectedCount function not working in QV12 SR1?

Chanty4u — Mon, 04 Apr 2016 06:16:49 GMT

did u try with?

GetNotselectedCount(Field,True())

or u can use by using " And " in parameters

Re: GetNotSelectedCount function not working in QV12 SR1?

Kushal_Chawda — Mon, 04 Apr 2016 06:22:21 GMT

sureshqv‌ right now I am in office so I will not be able to test it, I will try it out later. Thanks for the response

Re: GetNotSelectedCount function not working in QV12 SR1?

avinashelite — Mon, 04 Apr 2016 07:41:57 GMT

Hi Kush141087‌ I have tested it with QV12 it was working fine I didn't check with SR1 , will check and let you know

Re: GetNotSelectedCount function not working in QV12 SR1?

Chanty4u — Mon, 04 Apr 2016 08:29:59 GMT

Hi kush,

here there is some example and try this too.

GetNotSelectedCount with example

Re: GetNotSelectedCount function not working in QV12 SR1?

sunny_talwar — Mon, 04 Apr 2016 10:01:28 GMT

I am using QV12 because of the join related bug that we have came across in QV12 SR1. But is there a specific example you have where it isn't working?

Re: GetNotSelectedCount function not working in QV12 SR1?

Kushal_Chawda — Mon, 04 Apr 2016 10:04:00 GMT

I was simply using getnotselectedcount(Fieldname). I selected the value from Field and function shows 0 instead of not selected values count.

Re: GetNotSelectedCount function not working in QV12 SR1?

Chanty4u — Mon, 04 Apr 2016 10:06:23 GMT

did u chk dis qvw?

Re: GetNotSelectedCount function not working in QV12 SR1?

sunny_talwar — Mon, 04 Apr 2016 10:12:14 GMT

I have never used this function before, but the below image is from help section. Did you notice this:

GetNotSelectedCount ‒ QlikView

Re: GetNotSelectedCount function not working in QV12 SR1?

swuehl — Mon, 04 Apr 2016 10:13:28 GMT

GetNotSelectedCount() is only useful with AND mode list boxes.

See also the referenced thread above in my answer in

GetNotSelectedCount with example

Re: GetNotSelectedCount function not working in QV12 SR1?

Kushal_Chawda — Mon, 04 Apr 2016 10:16:56 GMT

I used it first time and never seen the help for usage . That's why it was not working. lol

Re: GetNotSelectedCount function not working in QV12 SR1?

sunny_talwar — Mon, 04 Apr 2016 10:18:35 GMT

I think there is a similar function called GetExcludedCount() which should work the way you expected

GetExcludedCount ‒ QlikView

Re: GetNotSelectedCount function not working in QV12 SR1?

Kushal_Chawda — Mon, 04 Apr 2016 10:19:46 GMT

Thanks swuehl‌. I missed to see the help. Instead I thought community will be faster.

Re: GetNotSelectedCount function not working in QV12 SR1?

swuehl — Mon, 04 Apr 2016 10:21:21 GMT

Yes, it's always good to check the Help if your expectations are not fulfilled.

The Help pages are more often right than wrong...