set analysis count if length or isnull

[stevenpiers]

Hi All,

Is there someone who could please help me out... 

I'm creating a table where I only want to see items with a discontinued status where the enddate equals ISNULL() or length <> 10.

For the isnull version I normally use [Count({<A = {"=Len(A)=0"}>} B)], but in this case it doesn't work? What am I doing wrong and how could I solve this.

In advance, thanks for your help!

[marcus_sommer]

Something like:  {"=Len(A)=0"} is not a set analysis else an if-loop within a set analysis. Beside this it's rather seldom useful to query anything for NULL else much easier would be to replace NULL within the script. An empty end-date might be replaced with today() or yearend(today()) or 31.12.9999 or string-values like: '<NULL>' or ' '. 

[vincent_ardiet_]

Try with:
Count({<A = {*}>} B)

[hic · Accepted solution]

If you have a primary key - like ItemID - in the table, it's straightforward: Something like
Count({<ItemID= E({<A={"*"}>})>} ItemID )

See also https://community.qlik.com/t5/Design/Excluding-values-in-Set-Analysis/ba-p/1471704

[stevenpiers]

Thanks all!