topic Re: Chart highlighting in QlikView

Chart highlighting

satishkurra — Thu, 29 Mar 2018 19:15:10 GMT

I'm trying to build reports for different counties

Attached is the sample app and data for reference.

I'm trying to highlight the bar or portion of the Pie with completly different color and rest of the bars/pie with 1 color

For example, Company A belongs to USA, Healthcare, Human resources and fall under 1-1000 size

When I'm generating the report for Company A, I should highlight USA, Healthcare, Human resources and fall under 1-1000 size with 1 color and the rest of the bars with another color

I CANNOT filter for each company as it result to 100 %.

Also i cannot hard code the color based on Company as it has around 500 companies

I need to highlight the bars/pie to which the company correspond to

When i'm sending the report for Company A, it should highlight USA, Healthcare, Human resources and fall under 1-1000 size with 1 color and the rest of the bars with another color

When i'm sending the report for Company B, it should highlight UK, Finance, Energy and fall under Less than 1000 size with 1 color and the rest of the bars with another color

and

So On.....

Is there any better way to achieve this?

Please help.

Re: Chart highlighting

jerifortune — Thu, 29 Mar 2018 19:59:37 GMT

Have you tried using expression for the color

IF(size='1-1000', '#778899','#008b8b')

If you want to give each size band a different color, you can create a color dimension during the load period

Size_Color:

Load *,

pick(match("Size",'1-1000','Less than 1000','> 1000'),RGB(250,120,0),RGB(50,130,164),RGB(140,120,8))as "Size Color"

Resident data;

Then set the color expression as [Size Color]

Re: Chart highlighting

satishkurra — Thu, 29 Mar 2018 20:19:35 GMT

I do not want to hard code the values as it contains different entries and not constant

Here is the thing,

If i need report for CompanyA, It should highlight the associated values for that Country as 1 color and Unassociated values in another color. AND we should not make a selection in Company as it results all charts to 100 %

Hope this clarifies...

Re: Chart highlighting

jerifortune — Thu, 29 Mar 2018 20:40:29 GMT

Not Clear of what you want to achieve. How would Qlik know that you need a report for CompanyA without making a selection? There should be something to trigger the color change.

Re: Chart highlighting

satishkurra — Thu, 29 Mar 2018 20:53:12 GMT

Yes. Even I'm thinking the same.

But there are some reports in Power point where it has been achieved by writing macros.

Not sure how to handle this in QlikView

Re: Chart highlighting

MarcoWedel — Thu, 29 Mar 2018 23:04:23 GMT

Hi,

one solution could be: