5 Replies Latest reply: Nov 28, 2016 11:36 AM by Luiz DePaula RSS

    How to make pie chart of sum of metrices as dimensions ?

    Ishu Mehta

      -----  QLIKSENSE --------

       

      I have made 3 tables in one of the sheets which are shown below

       

      Table 1 - Blog table -  ( Used formulae -->  if(WildMatch((landingPagePath, ' */blog* '),landingPagePath) )

       

      Blog pagesPage views
      /blog/blog13
      /blog/blog28
      /blog/blog316
      Total27

       

      Table 2 - Product table -  ( Used formulae -->  if(WildMatch((landingPagePath, ' */product* '),landingPagePath) )

       

      Product PagesPage views
      /product/product15
      /product/product26
      /product/product39
      /product/product422
      Total42

       

      Table 3 - Vacancy table -  ( Used formulae -->  if(WildMatch((landingPagePath, ' */vacancy* '),landingPagePath) )

       

      Vacancy PagesPage views
      /vacancy/vacancy110
      /vacancy/vacancy22
      /vacancy/vacancy33
      /vacancy/vacancy41
      Total16

       

      I made these tables in one sheet and on the same sheet, I would like to display a pie chart which shows how many blog,product and vacancy pages are visited. This means, I want to make a pie chart of below mentioned table (this table is in my mind , not in the sheet)

       

      pagesPageviews
      blog pages27
      product pages42
      vacancy pages16

       

      To make a pie chart, I used the similar formula (mentioned above)

      dimension -  if((WildMatch(landingPagePath, '*/blog*') or WildMatch(landingPagePath, '*/product*') or WildMatch(landingPagePath, '*/vacancy*')) , landingPagePath)

      measure -  sum(pageviews)

       

      The result of abpve formula was that, I got pie chart of below mentioned table

       

      pagespageviews
      /blog/blog13
      /blog/blog28
      /blog/blog316
      /product/product15
      /product/product26
      /product/product39
      /product/product422
      /vacancy/vacancy110
      /vacancy/vacancy22
      /vacancy/vacancy33
      /vacancy/vacancy41

       

      Can anyone help me with formula to be put in pie chart dimensions or measure fileds ?