2 Replies Latest reply: Sep 8, 2017 2:59 PM by Meghann MacDonald RSS

    Inclusive Count Function Formatting for Qlik Sense

    Meghann MacDonald

      Hi all,

      I am trying to format a gauge to count all URL's that have a Location = SFDC AND a Location = Qlik.com. I cannot get my function to work as I don't know the proper formatting. So far, I have

       

      Count(DISTINCT{<[LOCATION] ={"SFDC","Qlik.com"}>}[URL])

       

      that I know works, but includes all assets were Location = SFDC OR Location=Qlik.com

      If possible, I would also like to narrow this down further to include only Language=English and Format<>A4. This is my starting point...

       

      Count(DISTINCT{<[LOCATION] ={"Qlik.com"} and ([Language] = {"English"}>}[URL]))) etc.

       

      Thanks!