topic Re: Set two or more default selections in one field for a user in QlikView

Set two or more default selections in one field for a user

Mon, 26 Oct 2015 16:24:38 GMT

hi all,

I want to ask a question. I want to set two default selections in one filter for a specific user. so i went to

documet --> on open<has action> -->add-->selection-->select in field and wrote in value:

=IF(OsUser()='user1','selection1' | 'selection2')

but the code is wrong

Does enybady know the corrent code for this?

Re: Set two or more default selections in one field for a user

Anonymous — Mon, 26 Oct 2015 16:41:23 GMT

the Syntax for several values

(value1|value2)

in your case should be like

=IF(OsUser()='user1',('selection1' | 'selection2'))

I didnot get it work when I use if only with direct Definition

maybe in combination with if there must be another Syntax??

Re: Set two or more default selections in one field for a user

miguelbraga — Mon, 26 Oct 2015 16:52:28 GMT

Hi mate,

Why don't you use bookmarks? It seems a better solution for you

Hope it helps,

Regards,

Re: Set two or more default selections in one field for a user

Tue, 27 Oct 2015 08:45:35 GMT

Thank you guys

I think the only way is to use bookmarks

Re: Set two or more default selections in one field for a user

sasikanth — Tue, 27 Oct 2015 10:04:15 GMT

HI ,

Try something like this

IF(OsUser()='user1', '('&'"Selection1"'&'|'&'"Selection2"'&')' )

Re: Set two or more default selections in one field for a user

Tue, 27 Oct 2015 10:18:19 GMT

thank you! you solved my problem!

Re: Set two or more default selections in one field for a user

Tue, 27 Oct 2015 10:18:34 GMT

Hi,

Are there multiple users for which you require multiple selections? Afore mentioned solutions will be working fine for only 1 user.

Re: Set two or more default selections in one field for a user

jagan — Tue, 27 Oct 2015 10:27:24 GMT

Hi,

If values are static then you can directly give

=IF(OsUser()='user1','(selection1|selection2)')

Regards,

Jagan.

Re: Set two or more default selections in one field for a user

Tue, 27 Oct 2015 10:32:49 GMT

There is no problem in multiple users if you use 'or' statement.

For example:

=IF(OsUser()='user1' OR OsUser()='user2' ,'('&'"Selection1"'&'|'&'"Selection2"'&')' )

Re: Set two or more default selections in one field for a user

jagan — Tue, 27 Oct 2015 15:17:51 GMT

Hi,

For multiple users try like this

=IF(OsUser()='user1' OR OsUser()='user2' ,'(selection1|selection2)')

OR with Mixmatch() like below

=IF(MixMatch(OsUser(), 'user1', 'user2', 'user3', 'user4') ,'(selection1|selection2)')