topic Re: Passing Colors based on the user Login in Section access in QlikView

Passing Colors based on the user Login in Section access

Tue, 22 Sep 2015 09:42:57 GMT

Hi Guys,

I have created an application which will Change the color cheme of the application based on the Login user (using Section Access) but here i got struck with onething One user accessing the data of two customers(clients) , so the color of the application should change based on selection of customers button on the front end .

Let me give you all an example

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, ADMIN, ADMIN

USER,USER1,USER1

USER, USER2, USER2

USER, USER3, USER3

];

Section Application;

NoConcatenate

LOAD * INLINE [

USERID, Customer_Code, User_Role,v__ColorChange,

USER1,'ABC Company',1,'Violet'

USER1,'DEF Company',1,'Green'

USER2, 'ABC Company',2,'Violet'

USER3, 'DEF Company',3,'Green'

];

So based on the above code by default when user Logs in i am getting the expected result

CompanyData Shown ColorWe Get on report

For USER2 'ABC Company' 'Violet'

For USER3 'DEF Company' 'Green'

But for USER1 i require both so i am able to display the data for both but

"How can i get the color related to that company when that company is selected through Text Box"

like for user and on selection of ABC company it should show me Violet , for DEF Company it should show me green

For USER1 'ABC Company' 'Violet'

For USER1 'DEF Company' 'Green'

Please help me out from this as i have tried some features but the problem is that when we click on the clear button the color changes are getting back to default and These attributes should not be shown in current selections

Re: Passing Colors based on the user Login in Section access

Tue, 22 Sep 2015 11:58:04 GMT

Hi ,

Pls Is there anyone who could help me out ?

Re: Passing Colors based on the user Login in Section access

Anonymous — Tue, 22 Sep 2015 12:14:56 GMT

try to use textcolor or Background Color for your Dimension "CompanyDataShown" and define

"only(ColorWe Get on Report)

But you Need the Color whether as predfeined color like green(), red() or with rgb values

like ABC Company rgb(x,y,z)

in my example i have a Dimension and used the Color Definition i have in 1 column

Re: Passing Colors based on the user Login in Section access

Tue, 22 Sep 2015 12:37:49 GMT

Hi Rudolf,

Thanks for your time !!!..Actually i am using the color not just for charts but also for highlighting the Text color on Buttons and Background color and Labels .

Re: Passing Colors based on the user Login in Section access

Anonymous — Tue, 22 Sep 2015 12:43:43 GMT

this should be the same

if you select the Company (and only one Company) you canuse

the same Expression for textcolor etc.

"only(ColorWe Get on Report) as it contains only 1 Color for 1 company

Re: Passing Colors based on the user Login in Section access

Tue, 22 Sep 2015 12:47:07 GMT

How can i use the only function ?, Can i use it on Triggers/Actions ?

You have got any example which you can share so that it can be helpful for my understading

Re: Passing Colors based on the user Login in Section access

Anonymous — Tue, 22 Sep 2015 12:52:10 GMT

you can skip the only function if you ensure that only one value is selected.

you can use it on Triggers also if only one value is selected

I would test it on a button or Dimension and Color function

next step use Trigger etc.

one step by the other

Re: Passing Colors based on the user Login in Section access

Tue, 22 Sep 2015 14:55:04 GMT

Maybe i got you idea partially, let me try and come back

Re: Passing Colors based on the user Login in Section access

Tue, 22 Sep 2015 16:08:03 GMT

Many thanks !!