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@@@@

[vardhancse]

what you are trying to achieve by the straight table.

[robert99]

How did you get the happy sad face column

[vardhancse]

based on which condition u want that images

[#5]

HI Sasi

it's an assignment need to be done as is in the picture

sum of 2011,2010

column of year 2011 vs 2010 and also in %

and last column adding pic that indicates if there is positive or negative growth

tnx Avi

[vardhancse]

create one new expression with the condition required.

expand the options of expression.Backgroud color->definition->select images tab.

Here u can find all the smiley symbols.

Hope this helps.

[robert99]

I can't open your file (I'm at home)

But I never knew there was an option to have a face in QV. And can't find it

Thanks

[robert99]

Thanks

[#9]

Hi Sasi

im in a bigger problem

i cant deal with the basics of this tabele

like how do i show year only 2011

and how do i compare them

tnx Avi

[vardhancse]

n the script u can create one new field with condition that year=2011.

So that u can use that field in the chart.

Table_1:

LOAD

Year,

Month

If(Year = 2011) as Year_1

From table_1;

So that we can use Year_1 in chart so that it will show only year 2011