Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try with ='2'
Try
If(FK = 2, sum(value), Null())
or
If(FK = 2, max(value), Null())
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?
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.
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?
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.
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.
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)...
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