topic Re: Adding condition to the 'Select in Field' action button in QlikView

Adding condition to the 'Select in Field' action button

Fri, 27 Feb 2015 10:49:54 GMT

Hi everyone,

I am trying to create a button named 'Rec failed' for datasets that do not reconcile (hence 'Difference' <>0). Ideally, when this button is clicked, I want it to show records where difference does not equal to 0. The field for this would be 'Difference' , I have tried a few things for Search String, but they didn't work. Your help would be greatly appreciated here!

and to complicate things, my aim is to get these buttons work on different levels :- e.g. selecting fields where difference <> 0 at a Group level, selecting fields where difference <> 0 at a Property level, and selecting fields where difference <> 0 at a account level. (These levels are hierarchical where there are two groups, each group contains different number of property , and each property holds a number of accounts).

thanks a lot!

Michelle

Re: Adding condition to the 'Select in Field' action button

jpenuliar — Fri, 27 Feb 2015 10:58:40 GMT

Hi Michelle,

Add an action : Select in Field ; Field: "Difference" ; Search String: "0"

add another Action: Select Excluded; Field: "Difference"

This will select all values except "0" in your "Difference" field

Re: Adding condition to the 'Select in Field' action button

tresB — Fri, 27 Feb 2015 11:14:37 GMT

Check the attached sample qvw.

Re: Adding condition to the 'Select in Field' action button

Fri, 27 Feb 2015 14:44:08 GMT

Hi Jonathan,

Thanks for the reply! I tried this but it didn't work unfortunately.

Re: Adding condition to the 'Select in Field' action button

Fri, 27 Feb 2015 14:44:58 GMT

Hi,

Many thanks for the reply and your example. Can you explain a bit further as I don't understand some parts.

Re: Adding condition to the 'Select in Field' action button

jpenuliar — Fri, 27 Feb 2015 14:59:45 GMT

You may have to add/remove "" or '' where appropriate