How to setup a filter using values from multiple fields

Q&A
, ,
5

Hi @jitendral.yadav

You may be able to achieve this using a calculated field approach.

  1. OwnedDevices parameter control. This is something you have already created … a multi-value parameter
  2. For each of your device fields create a Selected flag calculated field as follows. The IN(NULL …) handles the case where you have Select All selected in the parameter.

Laptop Selected Flag
ifelse(contains(${OwnedDevices}, ‘Laptop’) OR IN(NULL,${OwnedDevices}), 1, 0)

Smartphone Selected Flag
ifelse(contains(${OwnedDevices}, ‘Smart Phone’) OR IN(NULL,${OwnedDevices}), 1, 0)

  1. Additional calculated field which combines all the Selected Flag calculated fields to give you a boolean result that you can use the filter the visual

Owned Devices Filter
ifelse({Laptop Selected Flag} = 1,
1, ifelse({Smartphone Selected Flag} = 1, 1, 0)
)

  1. On your visual add a filter on the Owned Devices calculated field where value equals 1

Regards,
Giri