Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Qlikview beginner

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

qlik straight table.png

Tags (2)
18 Replies
vardhancse
Valued Contributor II

Re: Qlikview beginner

what you are trying to achieve by the straight table.

robert99
Valued Contributor II

Re: Qlikview beginner

How did you get the happy sad face column

vardhancse
Valued Contributor II

Re: Qlikview beginner

based on which condition u want that images

Not applicable

Re: Qlikview beginner

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
Valued Contributor II

Re: Qlikview beginner

create one new expression with the condition required.

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

Here u can find all the smiley symbols.

Hope this helps.

robert99
Valued Contributor II

Re: Qlikview beginner

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
Valued Contributor II

Re: Qlikview beginner

Thanks

Not applicable

Re: Qlikview beginner

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
Valued Contributor II

Re: Qlikview beginner

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

Community Browser