Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

When to use < and >, { and }

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!

1 Solution

Accepted Solutions
Not applicable
Author

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))

View solution in original post

4 Replies
Not applicable
Author

In Set Analysis such as: -

SUM({$<Field={'ThisSelection'}>}SumMe)

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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))

Not applicable
Author

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.