topic Re: how to use if statement in chart expression in QlikView

how to use if statement in chart expression

Mon, 06 Feb 2012 10:24:03 GMT

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
1	1	10
2	1	15
3	2	9
4	3	8
5	3	12

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

Mon, 06 Feb 2012 13:24:18 GMT

Try with ='2'

Re: how to use if statement in chart expression

Mon, 06 Feb 2012 14:15:09 GMT

Try

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

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

Re: how to use if statement in chart expression

jagannalla — Mon, 06 Feb 2012 14:29:17 GMT

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

Mon, 06 Feb 2012 15:01:32 GMT

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

Mon, 06 Feb 2012 15:03:42 GMT

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

jagannalla — Tue, 07 Feb 2012 08:04:58 GMT

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

jagan — Tue, 07 Feb 2012 09:47:39 GMT

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

Wed, 08 Feb 2012 15:55:42 GMT

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

Wed, 08 Feb 2012 16:28:42 GMT

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

Wed, 08 Feb 2012 16:37:37 GMT

yes

Re: how to use if statement in chart expression

Wed, 08 Feb 2012 16:44:30 GMT

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

Wed, 08 Feb 2012 16:51:31 GMT

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

Wed, 08 Feb 2012 17:02:50 GMT

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

Wed, 08 Feb 2012 17:05:34 GMT

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

Wed, 08 Feb 2012 17:11:10 GMT

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

Wed, 08 Feb 2012 17:26:11 GMT

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

Wed, 08 Feb 2012 17:27:53 GMT

...How can I get a substring?

Re: how to use if statement in chart expression

Davidoff — Thu, 09 Feb 2012 14:26:29 GMT

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

Re: how to use if statement in chart expression

Fri, 10 Feb 2012 15:46:16 GMT

Thank you all for your answers ^^