13 Replies Latest reply: Apr 11, 2017 3:09 AM by Andrey Khoronenko RSS

    SQL in visualization (for example, instead of set analysis)

    vyacheslav guzanov

      Hello everyone,

       

      I know that SQL can be used in data load scripts in QS (there several threads on this topic here)

      What about expressions, for example instead of set analysis?

       

      Example

      In pseudo language:

      Provide SUM of Sales where Volume is equal or more than 200.

       

      in QS Set analysis script this is:

      Sum({$<Volume ={">=200"}>} Sales)

       

      Is it possible to write the equivalent SQL statement in expression?

       

      The reason is that sometimes I am completely lost with set analysis grammar.

      I review these 200-300 + character formulas with set modifiers, set operators and set identifiers and afraid to unwillingly summon some set analysis demon from parallel dimension executing this script.