topic Re: Change background Image Of Pivot Table Dynamically in QlikView

Change background Image Of Pivot Table Dynamically

AbhijitBansode — Mon, 14 Jan 2013 06:16:47 GMT

My end user wants to view different background image for pivot table depending upon selection in region field.

How to achieve this?

Re: Change background Image Of Pivot Table Dynamically

sujeetsingh — Mon, 14 Jan 2013 06:23:50 GMT

just go to Expressions<<<<clik on + sign of expression and then fo to Background ooption.....

writ the set analysis expression...

...if(getselection(Field)=100,Red(),Green())

or whatever you need to implement>

Re: Change background Image Of Pivot Table Dynamically

neha_shirsath — Mon, 14 Jan 2013 06:35:57 GMT

Hi Sparten,

Go to chart properties> Visual Ques and give the upper & Lower values as 0 for column. & select the background color.

See the attachment,Hope it will help you.

Re: Change background Image Of Pivot Table Dynamically

AbhijitBansode — Mon, 14 Jan 2013 06:40:10 GMT

Thank you.

but, I dont want to change the background clor instaed i want to change background image.

idea given by you works only for backgroung color.

Re: Change background Image Of Pivot Table Dynamically

AbhijitBansode — Mon, 14 Jan 2013 06:44:17 GMT

Thanks Neha,

This is again related to backgroung color.

I want to change backgroung image of chart.

Re: Change background Image Of Pivot Table Dynamically

Mon, 14 Jan 2013 06:57:51 GMT

try this

1. Settings-> User preference -> Design -> Check "Always Show design menu item"

2. Right click on chart -> "Custome format cell"

Re: Change background Image Of Pivot Table Dynamically

AbhijitBansode — Mon, 14 Jan 2013 07:17:36 GMT

Thank you vishwaranjan.

I think this is something similar to what i want.

From where to access/open "Custom Format Cell" dialog box?

Re: Change background Image Of Pivot Table Dynamically

sujeetsingh — Mon, 14 Jan 2013 07:17:58 GMT

ok then just post a sample and which images you want to change

Re: Change background Image Of Pivot Table Dynamically

Mon, 14 Jan 2013 07:26:09 GMT

keeping cursor on any value of pivote table then right clik, then you see the custom format cell option.

Re: Change background Image Of Pivot Table Dynamically

neha_shirsath — Mon, 14 Jan 2013 07:27:35 GMT

Hi Sparten,

You get "Custom Format Cell" option when you right click on the chart,Don't go in the chart properties below you get that option.

Re: Change background Image Of Pivot Table Dynamically

AbhijitBansode — Mon, 14 Jan 2013 07:43:33 GMT

take a look at attached file for details of my requirement.

Re: Change background Image Of Pivot Table Dynamically

AbhijitBansode — Mon, 14 Jan 2013 07:51:06 GMT

Thank you.

This is also not usable in my case.

Still,I'm not able to change background image using this option.

Re: Change background Image Of Pivot Table Dynamically

Mon, 21 Jan 2013 19:15:42 GMT

if this helps you, then you should give helpful.

thanks.

Re: Change background Image Of Pivot Table Dynamically

Mon, 21 Jan 2013 19:59:22 GMT

I would cheat a little - see attached.

Re: Change background Image Of Pivot Table Dynamically

prasad_dumbre — Tue, 07 May 2013 05:23:58 GMT

Hi Rebecca,

Can you please tell us , where/how you have used that Inline Field 'Image' in properties of pivote table ?

Re: Change background Image Of Pivot Table Dynamically

Tue, 07 May 2013 13:10:53 GMT

It actually isn't in the pivot table. That's what I meant by saying I "cheated" a little, sorry. If you move the pivot table, you will notice that the image is actually behind the pivot table, with the pivot background set to be transparent. Hope that helps!

Re: Change background Image Of Pivot Table Dynamically

Tue, 07 May 2013 13:24:36 GMT

You could "cheat" by making multiple pivot tables that are exactly the same but with the difference being the selected background picture under "Style" -> "Background". Then under "Layout" -> "Show" select conditional, and show the different tables depending on user selections.

Good luck,

Regards