Input Control in Webi

[Former Member]

Hi,

I have created input control like All, name, year, revenue.

for name, I created formula like

concatenation("Name of the Chart",[Name]) - Name of the chart AAAA

concatenation("Name of the year",[Year]) - Name of the year January.

But for All values, it displays multivalue.

Can anyone help on this how to display for selecting "All"

[former_member207878 · Accepted solution]

Can you please share screenshot?

[arijit_das]

When you select All, the object [Name] or [Year] will return multiple values. So, to display the content, you need to use a table. If you use =Concatenation("Name of the Chart",[Name]) in a free standing cell, it will display multivalue error.

** The entire page should be under scope of the input control.

Alternative 1: In a free standing cell, use the formula:

="Name of the Chart "+ReportFilter([Name])

Alternative 2: In a free standing cell, use the formula:

=If(Count([Name])>1;"Name of the Chart - All";Concatenation("Name of the Chart ";[Name]))

[Former Member]

Thanks a lot Arijit. Working perfectly

[arijit_das]

Please close the discussion if your issue is resolved.