topic Re: Change Sheet Colour Background using GetCurrentSelections in QlikView

Change Sheet Colour Background using GetCurrentSelections

imtiaz_ullah — Fri, 05 Jun 2015 13:53:58 GMT

Hi guys,

Not sure if this is the right way to achieve this, but I am trying to change the background colour of a sheet depending on a particular selection within a dimension.

I am currently using - =if(GetCurrentSelections(SurveyQuestions)='TEXT TO LOOK FOR',yellow(),white()) and although I know the current selection text is correct (am throwing it out to a textbox), the colour of the sheet doesn't change.

Perhaps there are better ways to achieve this?

Thanks

Immy

Re: Change Sheet Colour Background using GetCurrentSelections

imtiaz_ullah — Fri, 05 Jun 2015 14:04:21 GMT

Figured it out... GetFieldSelections!

Re: Change Sheet Colour Background using GetCurrentSelections

stigchel — Fri, 05 Jun 2015 14:05:27 GMT

Are you really sure?? When you use GetCurrentSlections the text I Aspect is "SurveyQuestions: TEXT TO LOOK FOR"

If you have takeb that into account, check capitalisation, qlikview is case sensitive.

You can better use

GetFieldSelections(SurveyQuestions)

So you don't have the extra text'. A working example is attached

Re: Change Sheet Colour Background using GetCurrentSelections

imtiaz_ullah — Fri, 05 Jun 2015 14:12:21 GMT

Yeah thanks Piet - I realised that in the end.

I have managed to get it work, but actually some odd behaviour still exists.

Essentially I have an image which when clicked I want it to apply a filter on the sheet. This in turn does "stuff", one of which is to change the colour background.

The only way I can see to do this is by adding an action to SELECT IN FIELD. Whilst this works and filters the sheet, the colour doesn't actually change. I have to actually select it within the list box.

It's almost like Qlik isn't simulating an actual click on the record in the list box when it does the SELECT IN FIELD action.

Does that make sense? If I click the actual record in the list box after, the colour changes, just not when I click on the image with the Action tied to it.

Re: Change Sheet Colour Background using GetCurrentSelections

stigchel — Fri, 05 Jun 2015 18:04:39 GMT

No, it does not make sense. Are you sure the value gets selected in the correct field. I've attached a working example, if that does not help you, can you attach a qvw that demonstrates this problem?

Re: Change Sheet Colour Background using GetCurrentSelections

imtiaz_ullah — Mon, 08 Jun 2015 07:14:42 GMT

Hi Piet,

I get the message (attached) when trying to open the qvw...

Any ideas?

Thanks

Immy

Re: Change Sheet Colour Background using GetCurrentSelections

stigchel — Mon, 08 Jun 2015 09:09:11 GMT

That message says you are using the (free) Personal Edition, which is only able to open qvw files created by others for a few times (I think 4). After that you can only use qvw files created by yourself. The option to embed a license in a qvw file is limited to QlikTech employees, which I'm not. So unless you get a license, you're unable to open my files, which brings me back to my previous question. Can you attach a qvw that demonstrates the problem?

If you are worried about data privacy, have a look at this:

Preparing examples for Upload - Reduction and Data Scrambling

Re: Change Sheet Colour Background using GetCurrentSelections

imtiaz_ullah — Thu, 11 Jun 2015 07:47:13 GMT

Good morning Piet - your example is almost perfect. It now works, although what is odd, is that if I have more than one picture to click on (in order to change background colour), I need to click the image twice each time as the first click sets the background back to white, the 2nd then turns it to the desired colour.

Thanks for you help thus far.

Immy

Re: Change Sheet Colour Background using GetCurrentSelections

stigchel — Thu, 11 Jun 2015 09:26:37 GMT

Hi Immy,

You're welcome, the reason it first turns white again is because of the condition in the button's action. You can change it to e.g.

=if(GetFieldSelections(SurveyQuestions)='Text to look for A','','Text to look for A')

for the first picture and e.g.

=if(GetFieldSelections(SurveyQuestions)='Text to look for B','','Text to look for B')

for the 2nd

And for the Sheet color

=if(GetFieldSelections(SurveyQuestions)='Text to look for A',yellow(),

if(GetFieldSelections(SurveyQuestions)='Text to look for B',red(),

white()))

Now when you click on a picture, the sheet will get the corresponding color, click the same again white and when you click on the other image it will immediately change to the other color.

Example attached again.

Re: Change Sheet Colour Background using GetCurrentSelections

imtiaz_ullah — Thu, 11 Jun 2015 09:33:37 GMT

Perfect! - Although now... If I click the same image once it's fine, if I click it again, it goes white, almost like I am removing the selection on the 2nd click?

Re: Change Sheet Colour Background using GetCurrentSelections

stigchel — Thu, 11 Jun 2015 09:43:41 GMT

Exactly, the condition checks whether the value is already selected, if it is it will select '', which is removing the selection. If you don't want that just change the action on the image to select in the field the value

Text to look for A

Re: Change Sheet Colour Background using GetCurrentSelections

Thu, 11 Jun 2015 10:01:08 GMT

Hi Piet,

as iam new to qlikview could u explain steps to do this .not able to understand from where colour is allocated and in list box how action is performing

Re: Change Sheet Colour Background using GetCurrentSelections

imtiaz_ullah — Thu, 11 Jun 2015 10:15:24 GMT

Yep - that's exactly what I went and did!

All working as expected now, seems like i just needed the rule on the background selection.

Thanks a lot - nice learning curve which I can use across the product going forward.

Immy

Re: Change Sheet Colour Background using GetCurrentSelections

Thu, 11 Jun 2015 10:20:43 GMT

Hi Imtiaz,

Could u please explain how it works and steps for implementing creating.

Kindly.

Re: Change Sheet Colour Background using GetCurrentSelections

stigchel — Thu, 11 Jun 2015 10:29:29 GMT

The select in field action is on a text box with image as background

So clicking on the image will select a value in the field, the sheet has a calculated color checking for which value is selected to set a different color