topic Select values that does not have a value in a field with button action in QlikView

Select values that does not have a value in a field with button action

reshmakala — Fri, 01 Jan 2016 00:51:29 GMT

Hi,

I have a scenario where I need to make selections in a field if it does not have an entry of another field. I need this as a button action. Can anyone help me please?

Attached are the sample docs.

Re: Select values that does not have a value in a field with button action

maxgro — Fri, 01 Jan 2016 02:31:49 GMT

see attachment

added another action to the button

select in field ID

='(' & Concat({$ <ID={"=len(trim(Type))=0"},Priority={High}>} ID, '|') & ')'

Re: Select values that does not have a value in a field with button action

reshmakala — Sat, 02 Jan 2016 02:04:55 GMT

Thank you so much!!