topic Re: Selection Requirements - Urgent ( object level) in QlikView

Selection Requirements - Urgent ( object level)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Selected areas must have a light blue highlight color of RGB(220, 235, 252) and pixel stroke on top and bottom of RGB( 196, 221,250). Text in the highlighted items must be bold text with color RGB(51,51,51). Other text is regular weight and color RGB (100,100,100). Font size in this area is 11pt.

The above is at an object level. How to achieve this in Qlikview. Please provide the necessary steps / syntax . Is this possible without using a macro.

Re: Selection Requirements - Urgent ( object level)

Anonymous — Tue, 07 Nov 2017 14:04:51 GMT

This post is urgently required. Please respond to this. How to achieve this in Qlikview.

Re: Selection Requirements - Urgent ( object level)

Or — Tue, 07 Nov 2017 14:09:53 GMT

If you have urgent requirements, contact a QlikView consultant or Qlik support...

Re: Selection Requirements - Urgent ( object level)

MK9885 — Tue, 07 Nov 2017 14:12:59 GMT

We probably require how many dimensions or what dimension and measures you are using?

And upon selection of what the color should change?

Selection of any thing on the dashboard or any particular dimension?

Perhaps a sample app already built from you would be more helpful with an expected output image

Re: Selection Requirements - Urgent ( object level)

Anonymous — Tue, 07 Nov 2017 14:22:31 GMT

Hi Aehman,

Default selections in qlikview in green. The requirement is on selection say in a current selections box, Selected areas must have a light blue highlight color of RGB(220, 235, 252) and pixel stroke on top and bottom of RGB( 196, 221,250). Text in the highlighted items must be bold text with color RGB(51,51,51). Other text is regular weight and color RGB (100,100,100). Font size in this area is 11pt.

All this should happen based on selection say in a current selections box. Can you please post the syntax to me based on all the above RGB color , text and font conditions. Please read above again . This is based on selection. Best if the solution is macro free. Post me the syntax

Thank you in advance.

Re: Selection Requirements - Urgent ( object level)

Anonymous — Tue, 07 Nov 2017 14:39:36 GMT

Hi Aehman, Correction to the above. Everything is based on object level selection such as selection in a list box. On selection instead of the default green that qlikview gives us, it should be the following

Please text me the syntax or steps how to achieve this. Thank you.

Re: Selection Requirements - Urgent ( object level)

MK9885 — Tue, 07 Nov 2017 14:43:07 GMT

Ok, I can see the urgency you have but there is no straight forward syntax you can write... but

Try below link

ListBox color

Or write a Macro which you don't want to

Change selection color

apart from that I do not see any other solution. Maybe you can try creating your own Qlikview theme?

But a single expression is not going to change the default color for Qlik from Green to something else.

Re: Selection Requirements - Urgent ( object level)

Anonymous — Tue, 07 Nov 2017 14:49:03 GMT

If possible give me a syntax.

Re: Selection Requirements - Urgent ( object level)

Colin-Albert — Tue, 07 Nov 2017 15:02:12 GMT

stephen-x.redmond‌ explains how this can be done in his book "QlikView Cookbook for Developers" by modifying the settings.ini file and applying a custom colour scheme.

I am not going to copy out the details from his book here as there are several steps to follow, depending on whether you are looking to do this on a desktop or server system. I suggest you either get a copy, or try this post as suggested earlier.

Change selection color

Re: Selection Requirements - Urgent ( object level)

MK9885 — Tue, 07 Nov 2017 15:04:05 GMT

Syntax can be given based on objects not overall...
Ex: Current Selection box can have a single expression, Pie Chart or Bar Chart or any table.

But overall you cannot change the color of all the objects or selection made by jut single syntax.

Sorry but you either use Macro or the use an extension in Web mode an it would automatically be use in server.

Re: Selection Requirements - Urgent ( object level)

Anonymous — Tue, 07 Nov 2017 18:03:45 GMT

Aehman and Colin Albert, I require specific conditions (like the pixel stroke to be included) .

I require all these conditions to be fulfilled on selection in list objects. How to achieve this?

Maybe you can send me a macro or some steps using actoions or some syntax. even if extensions are used they would not be specific to the requirement right. require something specific to the requitrement as given above.

Re: Selection Requirements - Urgent ( object level)

MK9885 — Tue, 07 Nov 2017 19:37:50 GMT

sorry I personally do not have answer to this.

while in that extensions you can change few values. Replace the first 2 CSS text with below value

/* Selected values */

.QvSelected {

background-color: #dcebfc;

color: #33333;

class: Pristina;

font-weight: bold;

}

/* Associated values */

.QvOptional {

background-color: white;

color: #333333;

font-weight: 900;

}

It would only give you selected color as what you require but not bold text..

Not sure how to do it.

Maybe someone else can help you.

Thanks.

Re: Selection Requirements - Urgent ( object level)

Anonymous — Tue, 07 Nov 2017 23:41:52 GMT

Hi Aehman, Can you tell me where the extension is and how to download it.

Do me a favour, Can you make changes to the extension and attach the extension here and tell me how I can use it in qlikview as I am very new to this.

Or Best is - can you attach the qlikview file which has the list box in it with the extension linked to it so that above condition is working. I am very new to this.

Thank you so much in advance.

Another Q - Is it ok to use the extensions in qlikview.

Re: Selection Requirements - Urgent ( object level)

MK9885 — Thu, 09 Nov 2017 19:19:18 GMT

Sorry for late reply but I think it would be challenging to me get it done.

Check the below link for correct answer.

It has extension as an attachment, you need to run it an add extension in your document settings to use it.

ListBox color

I can't help you more on this, sorry or write an macro.

Thanks.