Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Using functions in Set Analysis Modifier

Hi All,

1. Can i you use YEAR (FieldName)  in modifier on the left side of  = ?

or

2. Can i you use YEAR (Today()) in modifier on the left side of  = ?

or

3. Is it possible to create a set analysis like this below ?

= COUNT({$<Year(DateField) = {'2014'}>}[pina coladas])

If yes, please let me know how

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

in QlikView help you can find this for set analysis syntax


set_modifier ::= < field_selection {, field_selection }  >

field_selection ::= field_name [ = | += | ¬–= | *= | /= ] element_set_expression 


It seems you can only use fields on the left side of set modifier

View solution in original post

2 Replies
Highlighted
MVP
MVP

in QlikView help you can find this for set analysis syntax


set_modifier ::= < field_selection {, field_selection }  >

field_selection ::= field_name [ = | += | ¬–= | *= | /= ] element_set_expression 


It seems you can only use fields on the left side of set modifier

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

As Massimo correctly mentioned, you can only use Field names in SA modifiers. However, you can implement the same logic using advance search conditions in your modifiers. For example:

= COUNT({$<DateField = {"=Year(DateField) = 2014"}>} [pina coladas])


or


= COUNT({$<DateField = {"=Year(DateField) = $(=Year(Today()))"}>} [pina coladas])


Of course, your set analysis could be much simpler and faster if you calculated a set of date-related flags in your Calendar table. For example, if you had a "Current Year Flag" that you could call _CY_Flag, you could simply use it like this:


= COUNT({$<_CY_Flag={1}>}[pina coladas])


cheers,

Oleg Troyansky

Come and learn Set Analysis and Advanced Aggregation with me at www.masterssummit.com - take your QlikView skills to the next level!

Oleg Troyansky

Masters Summit for Qlik is going virtual! Nov 18th - I'll teach Advanced Set Analysis and AGGR