How to capture a name within a field

[Aitelli_805]

I would like to create a dimension to give me everything  within  equi that have description rain .   The field are po_number, material_description.  I'm trying to capture all the purchase order that have  rain inside the material_description. 
And I want to create a dimension with just material_description to only bring up rain.

po_number	material_description
123456	rain
893455	rain

[dplr-rn]

you will need set analysis.
something like Sum({<material_description={'rain'}>} Sales)
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

[Aitelli_805]

I'm not trying to sum. Would like to view all the rain listed which is related to a po number.

[dplr-rn · Accepted solution]

use only function put material_description as dimension and measure
Only({<material_description={'rain'}>} po_number)

[Kashyap_R]

hi

try this

if(decription='rain',po_number)

Thanks

[dplr-rn]

adding to kashyap.
you will need to un-select 'Inlude null values'. it will work
but please note that if statements are less efficient than set analysis. if your data size is not too high if statement should work fine from a performance point of view. But as a standard i always recommend to avoid them unless not other way