topic Re: Authorized only excluding Actulas in QlikView

Authorized only excluding Actulas

Fri, 14 Feb 2014 04:58:28 GMT

Hi All, I have this very simple example attached. I have Authorized field and then I have Actuals field. I would like to know what is in Authorized which is not in Actuals. I would like to do on front end only.

Thanks

Re: Authorized only excluding Actulas

Gysbert_Wassenaar — Fri, 14 Feb 2014 09:05:37 GMT

See attached qvw

Re: Authorized only excluding Actulas

Fri, 14 Feb 2014 17:18:57 GMT

Thanks

aggr(only({<Authorized -= p(Actuals) >}Authorized),Authorized)

Can You please explain

Re: Authorized only excluding Actulas

Gysbert_Wassenaar — Fri, 14 Feb 2014 17:34:33 GMT

aggr( ...something... ,Authorized): create a list of values; for each value of Authorized one value of something

only( ...set_modifier... Authorized): Return the value of Authorized, but only if the value is part of the set defined by the set modifier

{<Authorized -= p(Actuals) >}: restrict the set of Authorized values to those values that don't occur in the field Actuals

Re: Authorized only excluding Actulas

Fri, 14 Feb 2014 17:46:30 GMT

I am attaching my TEst5.qvw. Please let me know if we can do the same to get Original Recipient only. Thanks for your help.

= p(Actuals),, what does p means here.

Re: Authorized only excluding Actulas

Gysbert_Wassenaar — Fri, 14 Feb 2014 18:56:52 GMT

p() means possible. I'm afraid I don't understand what you want. You already seem to have the list of Original RecipientName values that do not exist in Actuals. A possible problem is that you and Qlikview have different definitions of equal. Qlikview is case-sensitive and that means that US\Faisal Mehmood is not the same as us\Faisal Mehmood. If you want to compare these values then I recommend you use the Upper or Lower function in the script on both these fields to make sure they have the same capitalization.

Re: Authorized only excluding Actulas

Fri, 14 Feb 2014 19:41:20 GMT

Thnaks