topic How to make pie chart of sum of metrices as dimensions ? in App Development

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

Mon, 28 Nov 2016 11:01:17 GMT

----- 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 pages	Page views
/blog/blog1	3
/blog/blog2	8
/blog/blog3	16
Total	27

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

Product Pages	Page views
/product/product1	5
/product/product2	6
/product/product3	9
/product/product4	22
Total	42

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

Vacancy Pages	Page views
/vacancy/vacancy1	10
/vacancy/vacancy2	2
/vacancy/vacancy3	3
/vacancy/vacancy4	1
Total	16

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)

pages	Pageviews
blog pages	27
product pages	42
vacancy pages	16

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

pages	pageviews
/blog/blog1	3
/blog/blog2	8
/blog/blog3	16
/product/product1	5
/product/product2	6
/product/product3	9
/product/product4	22
/vacancy/vacancy1	10
/vacancy/vacancy2	2
/vacancy/vacancy3	3
/vacancy/vacancy4	1

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

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

luizcdepaula — Mon, 28 Nov 2016 14:47:12 GMT

Hello Ishu,

Is the measure the same for all of them "Page views", and you want to be able to create dimensions by filtering with some restrictions?

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

Mon, 28 Nov 2016 14:56:29 GMT

I am sorry Luiz, I am not able to understand your question.

But I found a solution for it and my task is done now

Here is the solution for the pie chart

Dimension :-

=ValueList('Blog Pages','Product Pages','Vacancy Pages')

Measure :-

IF( ValueList('Blog Pages','Product Pages','Vacancy Pages') = 'Blog Pages',

Sum( if(WildMatch(landingPagePath, '*/blog*') , pageviews ) )

IF( ValueList('Blog Pages','Product Pages','Vacancy Pages') = 'Product Pages',

Sum( if(WildMatch(landingPagePath, '*/product*'), pageviews ) )

Sum( if(WildMatch(landingPagePath, '*/vacancy*'), pageviews ) )

)

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

luizcdepaula — Mon, 28 Nov 2016 15:31:50 GMT

Ishu,

I think you might be complicating the solution. The ValueList function is good to use when you have different measures that you want combine them into one pie chart.

As you have only one measure, [Pages Views], all you have to do is to apply an IF condition to the dimension. Try the example below.

Dimension:

if(WildMatch(landingPagePath, '*/blog*'),'Blog',

if(WildMatch(landingPagePath, '*/product*'), 'Product', 'Vacancy'))

Measure:

Sum(pageviews)

You don't need the ValueList as it is all in one measure.

Cheers,

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

Mon, 28 Nov 2016 16:20:55 GMT

Thanks Luiz,

It is also working.

Thanks for your help

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

luizcdepaula — Mon, 28 Nov 2016 16:36:56 GMT

You are Welcome.

This way also, will facilitate in case if you need to apply Set Analysis to the measure.

Good luck,