Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
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()))
Try with ='2'
If(FK = 2, sum(value), Null())
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 "If(FK = 2, sum(value), Null())" and "
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.
Sum(If(FK = 2, value, Null())
Hope this helps you. If it not works can you attach sample file.
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)...
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>)?