topic Re: Qlikview beginner in QlikView

Qlikview beginner

Thu, 13 Nov 2014 09:40:05 GMT

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

Re: Qlikview beginner

vardhancse — Thu, 13 Nov 2014 09:41:32 GMT

what you are trying to achieve by the straight table.

Re: Qlikview beginner

robert99 — Thu, 13 Nov 2014 09:48:14 GMT

How did you get the happy sad face column

Re: Qlikview beginner

vardhancse — Thu, 13 Nov 2014 09:52:00 GMT

based on which condition u want that images

Re: Qlikview beginner

Thu, 13 Nov 2014 09:52:20 GMT

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

Re: Qlikview beginner

vardhancse — Thu, 13 Nov 2014 09:58:25 GMT

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.

Re: Qlikview beginner

robert99 — Thu, 13 Nov 2014 09:59:01 GMT

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

Re: Qlikview beginner

robert99 — Thu, 13 Nov 2014 10:11:13 GMT

Thanks

Re: Qlikview beginner

Thu, 13 Nov 2014 10:13:12 GMT

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

Re: Qlikview beginner

vardhancse — Thu, 13 Nov 2014 10:31:33 GMT

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

Re: Qlikview beginner

robert99 — Thu, 13 Nov 2014 10:39:29 GMT

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

Re: Qlikview beginner

vardhancse — Thu, 13 Nov 2014 10:42:19 GMT

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.

Re: Qlikview beginner

robert99 — Thu, 13 Nov 2014 10:43:12 GMT

or in the expression

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

Sum (if Year = 2012, Revenue)

After you set up in script

year (Datefield) = Year,

load

ProductName,

Date,

Revenue,

Year (Date) as Year

from loadtable;

then in your chart set to stright atbel and

Dimension = ProductName

Expression as above

Re: Qlikview beginner

Peter_Cammaert — Thu, 13 Nov 2014 10:46:01 GMT

Two steps:

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

Re: Qlikview beginner

robert99 — Thu, 13 Nov 2014 10:55:00 GMT

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

I put the above expression in the background colour

It still didn't work

Re: Qlikview beginner

vardhancse — Thu, 13 Nov 2014 10:56:57 GMT

if condition satisfies one image and if not second image.

if((condition),1,1)

Re: Qlikview beginner

robert99 — Thu, 13 Nov 2014 11:00:26 GMT

Thanks

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

Re: Qlikview beginner

Thu, 13 Nov 2014 11:59:29 GMT

Thanks to you all

Re: Qlikview beginner

robert99 — Thu, 13 Nov 2014 12:48:38 GMT

Did you get the answer to your question?

If so mark the question as answered