Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
=if ( match(DocName_Sessions,'market dashboard.qvw'), 'market dashboard',null()) as DocName
Hello,
try like this:
if(DocName_Sessions<>'market dashboard.qvw', left(DocName_Sessions, len(DocName_Sessions)-4))
hope this helps
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.
try this
=if ( match(DocName_Sessions,'market dashboard.qvw'), 'market dashboard',null()) as DocName
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','')