2 Replies Latest reply: Feb 19, 2014 9:39 AM by Friedrich Hofmann RSS

    how to keep expression result

    Darri Hilmarsson

      Hi, Qlikview Community

       

      I am having a little trouble but it must be possible to solve it.

      In the blue column (first pic) I have a formula:

       

      count(DISTINCT total <%Key_CONSOL_JOB_HEADERS> JOB_REFERENCE)

       

      It purpose is to count how many job reference is in the first column (Key_CONSOL....)

      It is working great but I want keep those number the same all the time.

      When I select one Job reference this calculation changes (see second pic.).

      I understand why that happens but can I do something that let it not happen.

      Any smart ideas?

      QVpic23.JPG.jpg

      count(DISTINCT total <%Key_CONSOL_JOB_HEADERS> JOB_REFERENCE)

       

      QVpic45.JPG.jpg

        • Re: how to keep expression result
          Nicole Smith

          If you only want to ignore selections in the Job Reference field:

          count({<%Key_CONSOL_JOB_HEADERS=>}DISTINCT total <%Key_CONSOL_JOB_HEADERS> JOB_REFERENCE)

           

          If you want to ignore all selections:

          count({1}DISTINCT total <%Key_CONSOL_JOB_HEADERS> JOB_REFERENCE)

           

          You can also give the chart a different alternate state than the rest of the document if you want to ignore all selections.

          • Re: how to keep expression result
            Friedrich Hofmann

            Hi Darri,

             

            simple: Use set_analysis - look it up in the help_file. It is a very powerful tool that can get pretty complex.

            In your instance: Write

            >>> Count({1} ... ) <<< - that way, the parameter 1 will cause the calculation to be performed on the entire set of records, disregarding all user_selections.

            If you want to disregard most, but not all user_selections, that can be enhanced.

            HTH

             

            Best regards,

             

            DataNibbler