topic Re: Listbox creation with specific value in QlikView

Listbox creation with specific value

Wed, 25 Nov 2020 16:16:04 GMT

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:

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 — Tue, 03 May 2016 05:18:31 GMT

Hello,

try like this:

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

hope this helps

tamilarasu — Tue, 03 May 2016 05:24:48 GMT

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 — Tue, 03 May 2016 05:37:44 GMT

try this

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

Tue, 03 May 2016 14:48:43 GMT

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','')