topic Inserting image in pivot table in QlikView

Inserting image in pivot table

Thu, 15 Sep 2011 05:36:32 GMT

Hi,

In my pivot table, I am showing Sales for perticulat region. My requirement is that if the sale is below 100 then there should be one more field which will display a downwards arrow (something like '↓') and when sales is greater than 100 then upwards arrow. I tried to copy paste the arrow symbol from word but it is not supporting here. I also tried to insert sample images available in qlikview still it is giving error.

Please help me out.

Thanks in advance.

Inserting image in pivot table

its_anandrjs — Thu, 15 Sep 2011 05:54:21 GMT

Hi,

Use the Bundled info load in the qlikview no need to paste the image there it is generated automatically.

HTH

RGDS

Anand

Inserting image in pivot table

its_anandrjs — Thu, 15 Sep 2011 05:59:26 GMT

Hi,

Write some thing like this for your arrow code

If(Val>100,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

HTH

Rgds

Anand

Re: Inserting image in pivot table

its_anandrjs — Thu, 15 Sep 2011 06:03:58 GMT

Hi,

See the attached sample file.

HTH

Rgds

Anand

Re: Inserting image in pivot table

Thu, 15 Sep 2011 07:08:55 GMT

Please see this attached file...

Inserting image in pivot table

Thu, 15 Sep 2011 09:37:37 GMT

Hi Anand,

Thanks a lot for your answer. But as I have personal edition, I can not open file created by you.

But after using expression suggested by you it is working; just the thing is for displaying entire arrow, I need to resize my pivot table (which is not good), is there any way to resize the arrow?

Re: Inserting image in pivot table

Thu, 15 Sep 2011 09:38:11 GMT

Hi Anand,

Thanks a lot for your answer. But as I have personal edition, I can not open file created by you.

But after using expression suggested by you it is working; just the thing is for displaying entire arrow, I need to resize my pivot table (which is not good), is there any way to resize the arrow?

Re: Inserting image in pivot table

Thu, 15 Sep 2011 09:38:55 GMT

Hi,

As I have personal edition of qlikview, I can not open your file. But thanks for answer.

Re: Inserting image in pivot table

its_anandrjs — Thu, 15 Sep 2011 15:14:32 GMT

Hi,

To set the image setting for this use

Properties -> Expression -> select image expression -> then you check a image Formatting option right side from there -> there are 4 types of options available according to your use use them.

Rgds

Anand