3 Replies Latest reply: Jan 30, 2018 11:10 AM by Jonnie Yacoub RSS

    Exclude count less then x in Dimension/Expression

    Jonnie Yacoub

      Hey Qlikkerss,

       

      I have a visualisation where i show the conversion % of each city. For the dimension i use CityName and for the expression i use deal/lead. But i only want to show the City's that have more then 40 leads... Is there some way to show these? See below my expressions:

       

      count({1<[type]={'deal'},

      source-={'Via verhuurder'},

      [date]={'>=01/03/2017'}>}

      type)

      /

      count({1<[type]={'lead'},

      leadsource -={'Via verhuurder'},

      [date]={'>=01/03/2017'}>}

      type)

       

      Thanx, Jonnie

        • Re: Exclude count less then x in Dimension/Expression
          Gysbert Wassenaar

          perhaps like this:

           

          count({1<[type]={'deal'},

          source-={'Via verhuurder'},

          city={"=count({1<[type]={'lead'}>} type)>40"}

          [date]={'>=01/03/2017'}>}

          type)

          /

          count({1<[type]={'lead'},

          leadsource -={'Via verhuurder'},

          city={"=count({1<[type]={'lead'}>} type)>40"}

          [date]={'>=01/03/2017'}>}

          type)

            • Re: Exclude count less then x in Dimension/Expression
              Jonnie Yacoub

              I thought it was something like that, but it did not work.. Added the missing komma's and tried to change city to type but still not the answer...

               

              count({1<[type]={'deal'},

              source-={'Via verhuurder'},

              city={"=count({1<[type]={'lead'}>} type)>40"},

              [date]={'>=01/03/2017'}>}

              type)

              /

              count({1<[type]={'lead'},

              leadsource -={'Via verhuurder'},

              city={"=count({1<[type]={'lead'}>} type)>40"},

              [date]={'>=01/03/2017'}>}

              type)

               

              then i tried only to count the leads with the expression below but it also showed me the count with less then 40...

              count({1<[type]={'lead'},

              leadsource -={'Via verhuurder'},

              city={"=count({1<[type]={'lead'}>} type)>=40"},

              [date]={'>=01/03/2017'}>}

              type)

               

              Also tried this, and then it worked... But i need the other Set Analysis modifiers...

               

              count({1<city={"=count({1<[type]={'lead'}>} type) >=26"}>}

              type)

                • Re: Exclude count less then x in Dimension/Expression
                  Jonnie Yacoub

                  gwassenaar this expression did the trick, i had to add the conditions in the second analysis to. The problem is it shows me zero values.. And i alreay unchecked the "Suppress zero values" box... Any idea how to hide the zero values or the values <40??

                   

                  count({<[type]={'deal'},

                  source-={'Via verhuurder'},

                  [date]={'>=01/03/2017'}>}

                  type)

                  /

                  count({<date={'>=01/03/2017'},

                  leadsource-={'Via verhuurder'},

                  name={"=count({<[type]={'lead'},

                  date={'>=01/03/2017'},

                  source-={'Via verhuurder'}>}

                  type)>=40"}>}

                  type)