Listbox creation with specific value

[#1]

Hello,

I am taking data from the Governance dashboard to create a specific statistic app. I use Binary load to bring all data into my new app.

Then, I attempted to create a ListBox with the following field "DocName_sessions"

The ListBox contains the following:

DocName_Sessions
governance dashboard.qvw
ab_dashboard.qvw
ccn_dashboard.qvw
market dashboard.qvw
inv dashboard.qvw

Now I want to exclude all except for "market dashboard.qvw" and I also want to exclude ".qvw" at the end.

I entered the below code in the Expressions and the result just show duplications.

if(match(DocName_Sessions,'governance dashboard.qvw','ab_dashboard.qvw','ccn_dashboard.qvw','inv dashboard.qvw'),DocName_Sessions)

I am sure there is a way to do this.  Thank you for your assistance in advance!

Regards,

Pat

[zhadrakas]

Hello,

try like this:

if(DocName_Sessions<>'market dashboard.qvw', left(DocName_Sessions, len(DocName_Sessions)-4))

hope this helps

[tamilarasu]

You can try like below,

=if(Not match(DocName_Sessions,'market dashboard.qvw'),Replace(DocName_Sessions,'.qvw',''))

=if(match(DocName_Sessions,'market dashboard.qvw'),Replace(DocName_Sessions,'.qvw',''))

Update: I have misunderstood the question. Now, corrected the expression.

[Kushal_Chawda · Accepted solution]

try this

=if ( match(DocName_Sessions,'market dashboard.qvw'), 'market dashboard',null()) as DocName

[#5]

Here is the result from the provided suggestions

As yo can see it duplicates the values.  All I want to show in this listbox is "Sales Dashboard".

here is the expression:

//if(DocName_Sessions<>'sales dashboard.qvw',left(DocName_Sessions,len(DocName_Sessions)-30))

//if(match(DocName_Sessions,'sales dashboard.qvw'),'sales dashboard.qvw',null())

Replace(DocName_Sessions,'.qvw','')