19 Replies Latest reply: Feb 10, 2012 10:46 AM by present02

# how to use if statement in chart expression

Hi all,

I need to use IF statement in an expression  for a standard chart; I'm explaining with an example.

I have a table like this:

PK
FK
value
1110
2115
329
438
5312

User may select (or not) a set of data with different values for FK and cannot select FK values, but the chart has to create an expression like this:

Show the trend of values having FK = 2.

I may consider to implement a second line with a different FK value, and compare it with the first one.

I already used an expression like this:

`If(value > genericVar, value, Null())`

it seems it works very well.

`If(FK = 2, value, Null())`

it seems it doesn't work very well - how to do?

`Count(If(FK = 2, value, Null()))`

it seems it works very well.

Thank you

• ###### how to use if statement in chart expression

Try with ='2'

• ###### Re: how to use if statement in chart expression

Try

`If(FK = 2, sum(value), Null())`

or

If(FK = 2, max(value), Null())

• ###### Re: how to use if statement in chart expression

Can you tell me little bit more.. Show any output with example. what you want according to your data?

what is the dimension?

What is the result you want?

• ###### Re: how to use if statement in chart expression

Use the first table, then the expression has to use values with FK = 2; the chart result must be:

when the user will select FK <> 2, then the chart cannot show any data.

• ###### Re: how to use if statement in chart expression

I tried FK = '2', but it still seems it doesn't work.

`Do "If(FK = 2, sum(value), Null())" and "`If(FK = 2, max(value), Null())" modify the value of record?

• ###### Re: how to use if statement in chart expression

Do you want this result means..

Just goto properites -> presentation tab -> uncheck suppress zero values.

- if not please explain clearly what you want step by step.

• ###### how to use if statement in chart expression

Try this,

`Sum(If(FK = 2, value, Null())`

Just goto properites -> presentation tab -> uncheck suppress zero values.

Hope this helps you.  If it not works can you attach sample file.

Regards,

Jagan.

• ###### Re: how to use if statement in chart expression

mmm I tried with an example and expressions now work as well...

Maybe a bug in my expression...?

You can see an example (see attachment)...

• ###### how to use if statement in chart expression

Another question.

If works with number: If ([var] = 1, <do this>, <else do this other>);

How does it work with string? Can I do this If ([var] = 'var', <do this>, <else do this other>)?

Thank you

• ###### Re: how to use if statement in chart expression

yes

• ###### Re: how to use if statement in chart expression

Your example it's ok, what is the problem? Take attenction that 0 it't different to null()

• ###### Re: how to use if statement in chart expression

Tried to use 'AA01' instead 1 and 'AA02' instead 2: the chart doesn't work.

The expressions If(status = 'AA01', QTA, 0) and If(status = 'AA02', QTA, 0) always return 0: the lines are fully 0...

This is my problem.

• ###### Re: how to use if statement in chart expression

In example Test.qvw I can't see status='AA01' or 'AA02', I see only 1 and 0002 .

• ###### Re: how to use if statement in chart expression

That's an old example. After that post I tried to use new set of data (with AA01 and AA02) and now it works. My real document doesn't want to compare a column with a string :/ dunno why.

• ###### Re: how to use if statement in chart expression

Your example it's ok, it works. Try to post a screenshot where we can see the column with data and the chart expression

• ###### Re: how to use if statement in chart expression

I already changed my document some weekes ago making a table per status, but I thought that was not a good solution and QlikView must do a string compare in expression... So I wrote here.

The example is similar to my document, the problem is not only referring to a document, but I just need to know how to do in general.

• ###### Re: how to use if statement in chart expression

...How can I get a substring?

• ###### Re: how to use if statement in chart expression

=IF( Left(Examplestring,5) = 'Hello', Thenaction, Elseaction)