Qlikview beginner

[#1]

HELLO EVERYONE

Im new to qlikview

i tried to make a Straight Table  but couldn't make it

need your help !!!!

attached file

tnx Avi@@@@

[robert99]

Ive tried this but the smiley face does not show

I posted this in background colour

'qmem://<bundled>/BuiltIn/smiley1_g.png'

Do I need to change another setting

Thanks

[vardhancse]

we should give some condition in the expression, so based on that condition the smiley symbol will be displayed.

With out expression condition it can not be done.

[robert99]

or in the expression

sum ({<Year = {2012} >} Revenue)

or

Sum (if Year = 2012, Revenue)

After you set up in script

year (Datefield) = Year,

ie

load

ProductName,

Date,

Revenue,

Year (Date) as Year

from    loadtable;

then in your chart set to stright atbel and

Dimension = ProductName

Expression as above

[Peter_Cammaert]

Two steps:

1. When adding an image column in a table (either pivot or straight), create an expression that tests conditions (using IF() function) and returns a single built-in image path. The paths can be selected in the Expression Editor in the tab "Images" at the bottom.
2. IMPORTANT: in the expression overview of your chart, select the expression for the image column, and in Display Options, select Representation = Image

That's it.

[robert99]

if (1=1 , 'qmem://<bundled>/BuiltIn/smiley1_g.png')

I put the above expression in the background colour

It still didn't work

[vardhancse]

if condition satisfies one image and if not second image.

if((condition),1,1)

[robert99]

Thanks

I posted the image in the actual expression (not the background colour. And changed to image and it worked

[#9]

Thanks to you all

[robert99]

Did you get the answer to your question?

If so mark the question as answered