topic Re: RE:Get Not working in QlikView

RE:Get Not working

kicchu465 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am using this in text object its not working

what is the issue?

am using the Qlikview 12 SR2

text object expression used:= ='GetExcludedCount:-'&GetExcludedCount(Product_category)

but it is giving "0" result

in that field I have 10 values I selected 2

can anyone give the explanation?

thanks

Re: RE:Get Not working

avinashelite — Fri, 27 Oct 2017 10:30:55 GMT

as per i know GetExcludedCount() you cannot use on the field your making selection it will give the excluded count of other field apart from the field your selecting

Re: RE:Get Not working

avinashelite — Fri, 27 Oct 2017 10:32:27 GMT

add the field other than field your making section...e.g. if your making selection on field A then use the expression on other field like GetExcludedCount(B)

Re: RE:Get Not working

vineetadahiya12 — Fri, 27 Oct 2017 10:45:38 GMT

Hi SK,

To make GetExcludedCount(Product_Category) return a value, you need to make selection on any other field. This will not work when you are selecting in Product_Category and expecting the excluded count.

Cheers

Vineeta