topic Re: Visual cue - table chart in QlikView

Visual cue - table chart

Thu, 07 Feb 2013 17:59:09 GMT

Hi,

I would like to insert a simple image dot to preceed a project name which will denote that the project is new i.e. that the creation date is within the last 14 days.

Can you please advise how to go about this? I am using a straight table chart. I have the IF statement working, so it is the actual visual representation that I need help with.

Ideally, I would like the dot to appear in the project name column rather than a separate column.

Many thanks,

Alan

Re: Visual cue - table chart

Gysbert_Wassenaar — Thu, 07 Feb 2013 18:12:29 GMT

You can't get it in the same column as project name.

Try this expression: if( today()-creation_date < 14, 'qmem://<bundled>/BuiltIn/led_0.png'). Then for that expression set Representation to Image and Image Formatting to Keep Aspect.

If you're willing to stick to simple ascii characters instead of an image you could use a calculated dimension. Something like: if( today()-creation_date < 14, ProjectName & ' *', ProjectName)

Re: Visual cue - table chart

Fri, 08 Feb 2013 11:26:20 GMT

That worked - many thanks Gysbert.

Can I resize the image that appears?

If I wanted to add a custom image, what would I need to do?

Re: Visual cue - table chart

Gysbert_Wassenaar — Fri, 08 Feb 2013 11:48:45 GMT

You can load custom images with a Bundle load. See here for an example. Once you've loaded the images in a table you can find pick them in the expression editor on the Images tab. Choose your table name as Image Folder.

If you want to resize your image change the Image Formatting options. Those are the only options available though.

Re: Visual cue - table chart

Fri, 08 Feb 2013 12:38:28 GMT

Again, many thanks.

Last question (I hope) - when I export the table to excel the image path displays and not the image.

Is there a way to fix this so that I can either a) take the image to excel b) insert a text label in its place c) remove the column altogether.

Thanks,

Alan