topic Re: Expression to only show unmapped fields in QlikView

Expression to only show unmapped fields

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

I need an expression that removes all of the categories that have values but only shows the unmapped ones at the bottom for another table! Is it even possible?

So I really only want to see the 939 values, nothing else.

Thanks!

Re: Expression to only show unmapped fields

sunny_talwar — Thu, 05 Apr 2018 14:28:22 GMT

May be change the Category dimensions to this

If(Len(Trim(Category)) = 0, 1, 0)

and then check 'Suppress When Value Is Null' on the dimensions tab

Re: Expression to only show unmapped fields

vishsaggi — Thu, 05 Apr 2018 14:32:41 GMT

What is your current expression? may be like

Dim: Category, Month

Expr:

= Sum({<Category = {"= Len(Trim(Category)) = 0"} >}Val)

Created some sample and got below is this what you are looking for?

Re: Expression to only show unmapped fields

khaycock — Thu, 05 Apr 2018 18:02:18 GMT

I changed the 1 to unmapped (and reloaded the data so there is now 1089 not 939) but what do I do about the 114 mapped to 0?

I also have suppressed the dimension when null and it didn't go..

Re: Expression to only show unmapped fields

khaycock — Thu, 05 Apr 2018 18:07:14 GMT

Using this expression (with my appropriate field names) returned these results:

sum({<CATEGORY= {"= Len(Trim(CATEGORY)) = 0"} >}SHIPPED_QUANTITY)

Re: Expression to only show unmapped fields

sunny_talwar — Thu, 05 Apr 2018 18:12:47 GMT

My bad... should be this

If(Len(Trim(Category)) = 0, 'Unmapped')

Re: Expression to only show unmapped fields

vishsaggi — Thu, 05 Apr 2018 18:25:44 GMT

Did you suppress 0 values in your Presentation tab? And if possible can you share your sample file. Did you try Sunny's updated expr?