topic Re: Color setting based on OSUser in QlikView

Color setting based on OSUser

Thu, 24 Apr 2014 18:01:38 GMT

Hi All,

I'm trying to set the color of bars in a graph when a user logs in to show ones that relate to them, but with no selections made.

I've got a version of this function working, but it requires a user to make a selection before this happens. What I'd like is to have this happen on login without any macros (as the client version needs to be Ajax).

Any thoughts?

Thanks

Gavin

Re: Color setting based on OSUser

Thu, 24 Apr 2014 18:20:26 GMT

Maybe some OnOpen trigger?

Re: Color setting based on OSUser

jaimeaguilar — Thu, 24 Apr 2014 18:24:43 GMT

Hi,

try modifying the background color property in your expression with:

=pick(WildMatch(OSUser(), 'Domain\User1', 'Domain\User2', 'Domain\User3'), Green(), Red(), Yellow())

You just have to replace the users and the colors you wish to use,

see the attached example,

regards

Re: Color setting based on OSUser

Thu, 24 Apr 2014 18:33:13 GMT

Thanks, I think that the trigger may work, but not sure what to use for it.

Jaime, the example you posted is helpful, but what I want to do is color just one of the bars (say Green) and the rest stay blue.

So if there was a bar chart that showed division and I had 5 divisions, I only want the division I belong to be color changed, the rest stay as they were.

thanks

Gavin

Re: Color setting based on OSUser

jaimeaguilar — Thu, 24 Apr 2014 18:51:12 GMT

Hi,

then you have to add the condition for changing just one bars, besides the condition for the color depending on OSUser():

if(CONDITION_IS_TRUE,

pick(WildMatch(OSUser(), 'Domain\User1', 'Domain\User2', 'Domain\User3'), Green(), Red(), Yellow())

)

this way, the bar will change color only if the condition is fulfilled,

regards

Re: Re: Color setting based on OSUser

maxgro — Thu, 24 Apr 2014 18:58:40 GMT

Re: Color setting based on OSUser

Thu, 24 Apr 2014 19:12:13 GMT

Hi massimo

Can you post up the qvw?

Many thanks

Gavin

Re: Color setting based on OSUser

maxgro — Thu, 24 Apr 2014 20:09:34 GMT

is already attached to my prev post

Re: Color setting based on OSUser

Fri, 25 Apr 2014 07:11:38 GMT

Hi Massimo,

Yes it was (my mistake) I was looking through a mobile device that didn’t pick-up the attachment.

Many thanks

Gavin