Hello Faisal,
I think you have "just" a simple filter expression which compares your parameter IP_Div against your Division column. In case of an empty division parameter that filter expression is not ignored and all values are filtered out, cause no one is blank.
To get your values you have to adjust your filter expression, to consider that case. For instance like following:
if('$$IP_Div$$' = '',match("Division",'*'),match("Division",'$$IP_Div$$'))
I used "Division" as your column name (if you renamed it for the output please adjust it to the name you have available in the data source).
Regards,
Florian
Hi Florian, if we have input parameter with multiple input values? then will we need to change else condition with "In" instead of Match?
Add comment