topic Re: Omit Data in Dimension in QlikView

Omit Data in Dimension

pandreozzi — Thu, 07 Dec 2017 16:25:18 GMT

I have request. In the screen shot below what I would like to accomplish is to not include the fields where the Border_Date_Asset =1. My goal is to have this reflected in the Date Discrepancy Found column so in essence if Border_Date_Asset = 1 then omit. In the Date Discrepancy Found field in the dimension I have started the expression so I think this is where I need to add a reference to the Border_Date_Asset.

Current Expression:

=if(IsNull([Date Discrepancy Found]) and BORDER_DATE_ASSET=0,date(DATE_INSTALLED_ASSET),date(Today()))

Screen Shot:

Re: Omit Data in Dimension

YoussefBelloum — Thu, 07 Dec 2017 16:42:52 GMT

Hi,

you need to apply the part of your condition (BORDER_DATE_ASSET=0..) on every expression you have on the table to be able to completely omit the value 1

Re: Omit Data in Dimension

pandreozzi — Fri, 08 Dec 2017 12:31:51 GMT

Thanks Youssef. I found a solution and that is on the chart I under properties there is an expression tab. I created an expression using the (BORDER_DATE_ASSET<>1) and in doing so I am pretty sure this applies to the entire chart so I do not need to apply this to each dimension within the chart. I am validating as I write this back to you but so far it looks good.

Thanks, I will mark this as helpful

Paul

Re: Omit Data in Dimension

YoussefBelloum — Fri, 08 Dec 2017 12:50:07 GMT

when i opened the screen shot i saw columns named "count..." so i thought that you already have expressions on the table. that's why i told you to put the conditions on all the expressions.

Good Luck !

Re: Omit Data in Dimension

pandreozzi — Fri, 08 Dec 2017 12:55:42 GMT

no worries. I am still learning this app so most is an experiment to me. I do appreciate all the help throughout this community.