topic Re: Documentation for Operators and Functions in QlikView

Documentation for Operators and Functions

Anonymous — Wed, 22 Apr 2015 22:32:15 GMT

Is there detailed documentation that lists all possible Operators and Functions for Set Analysis and Expressions in general?

An example of something that I can't find in the Help documentation is $::, so Dollar sign Colon Colon, tells the set analysis to use the selected Dimension as the pass through. We were fortunate to be able to find a thread here on the forums discussing this particular ability.

Re: Documentation for Operators and Functions

Oleg_Troyansky — Wed, 22 Apr 2015 22:37:51 GMT

I'd say that the Help Article "Set Analysis" provides an (almost) complete overview of the Set Analysis syntax. The reason that the $:: notation was there, I believe, is because it belongs to the Alternate States materials, and that relatively new addition didn't make it to the article, which was obviously older. So, the combination of the "Set Analysis" article and the Alternate States article(s) is perhaps the most complete source.

I'm not aware of anything more complete, even though there is plenty of Set Analysis information scattered in blogs, books, etc...

cheers,

Oleg Troyansky

Come and learn Set Analysis and Advanced Aggregation with me at the Masters Summit for QlikView - www.masterssummit.com

Re: Documentation for Operators and Functions

ziadm — Wed, 22 Apr 2015 22:48:52 GMT

excellent wizard to make a set analysis http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

Re: Documentation for Operators and Functions

maxgro — Wed, 22 Apr 2015 22:50:35 GMT

for set analysis I think the best doc is

Set Analysis: syntaxes, examples