Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys. Quick, easy question for you.
When do you need to use < > in an expression?
When do you need to use { } in an expression?
I've built about two dozen expressions now, but have never used these. Wondering if that might be an issue for me.
That's it. Thanks!
So, let me ask you this: Should I have used them in this expression?
sum( if (APEL_LTR_SNT_DT-[Received Date]<=60 and DSFT_SEVY_DS = 'Standard60' and APEL_DS = 'Denial Overturned',1)) / count( if ( DSFT_SEVY_DS = 'Standard60' and APEL_DS = 'Denial Overturned', DSFT_ID))
In Set Analysis such as: -
SUM({$<Field={'ThisSelection'}>}SumMe)
The < and > are used in comparison: if( value1>value2, 'value1 is larger than value2') and in combination with the total keyword: sum(total <Product> Sales) to return the total sum over the dimension Product. See attached example.
So, let me ask you this: Should I have used them in this expression?
sum( if (APEL_LTR_SNT_DT-[Received Date]<=60 and DSFT_SEVY_DS = 'Standard60' and APEL_DS = 'Denial Overturned',1)) / count( if ( DSFT_SEVY_DS = 'Standard60' and APEL_DS = 'Denial Overturned', DSFT_ID))
Will Qlikview know that I'm doing set analysis, or do I need to put the curly brackets and angle brackets somewhere in the expression? The expression as it stands DOES give me results - I'm just wondering if I might be missing some data by not using the right modifiers.