topic Re: how to create pie chart with multiple measures in App Development

how to create pie chart with multiple measures

Wed, 30 Mar 2016 10:55:04 GMT

Hi,

I have a measure name AMOUNT from raw data .then i have calculated three calculated measures named CalcA,CalcB,CalcC from AMOUNT and I want to create a pie chart with these three calculated measures only. I don't want to take any dimension for this pie chart. The requirement is there will be a pie chart which shows three section of Amount and section name will be like CalcA=20%, CalcB=70%,CalcC=10%.Can Anyone please help me in this problem

Re: how to create pie chart with multiple measures

sunny_talwar — Wed, 30 Mar 2016 11:20:43 GMT

CalcA, CalcB and CalcC are fixed? Do you have a sample you can share?

Re: how to create pie chart with multiple measures

Wed, 30 Mar 2016 12:37:14 GMT

Let me explain what are these measures

Customer Region Sales

A Delhi 10

B Mumbai 20

C New York 30

D Sydney 30

E Bangkok 30

F Singapore 50

CalA= Sum({$<customer={"A","B"},Region={"Delhi ","Bangkok"}>}Amount)

For the same manner CalB and CalC are measured.

Now i want create a pie chart which shows the share of amount basis of CalcA,CalcB,CalcC

For Example : one section will show

Name= CalA

Value = 30%

Re: how to create pie chart with multiple measures

mohamed_ahid — Wed, 30 Mar 2016 14:50:50 GMT

sample bellow .

Re: how to create pie chart with multiple measures

sunny_talwar — Wed, 30 Mar 2016 15:09:20 GMT

Something like this?

Expression1

Expression1/RangeSum(Expression1, Expression2, Expression3)

Expression2

Expression2/RangeSum(Expression1, Expression2, Expression3)

Expression3

Expression3/RangeSum(Expression1, Expression2, Expression3)

Re: how to create pie chart with multiple measures

Thu, 31 Mar 2016 04:29:17 GMT

Hi,

I agree above your solution will give three new calculated measures Expression1,Expression2,Expression3. So can you please tell me how to use these three measures to create a pie chart as what the default condition I can use only one dimension and one measure for pie chart.

Secondly the qvf file you have attached has same sample data in script writer tab. Can you please tell me what is the purpose of attached file . Sorry may be i couldn't find the use of it.

Re: how to create pie chart with multiple measures

kaushiknsolanki — Thu, 31 Mar 2016 10:13:07 GMT

Dear Rohit,

You are right you can use the one expression when you are having any dimension.

If you do not have dimension then you can have multiple expression to make a pie chart.

Using same concept experts has given you the solution.

Regards,

Kaushik Solanki

Re: how to create pie chart with multiple measures

Fri, 01 Apr 2016 05:07:02 GMT

Hi Kaushik,

Here the case is i have only three calculated measures not any dimension. So as you stated above, how can i use multiple calculated measures to form a PIE chart. while i am creating it , it ask one dim and one measure and when i try to drag second measure it ask for replace first one or cancel. Can you please help me how to select multiple measure while creating pie chart

Re: how to create pie chart with multiple measures

Fri, 01 Apr 2016 05:08:29 GMT

Hi AHID,

while i am trying to open your attached file , it is saying file contain no data and when i am checking in scripting part there is also nothing. May be i am opening it with wrong manner, can u please help me to guide how to open your attached file

Re: how to create pie chart with multiple measures

kaushiknsolanki — Fri, 01 Apr 2016 07:04:34 GMT

Hi Rohit,

I got what you are looking for.

You are right. Actually you are looking for a pie chart in Qlik Sense and not in Qlik View.

Till now we were talking about Qlik View and not Qlik Sense.

As of now Qlik Sense do not allow multiple expressions by default.

If you want to achieve this then only way is to make your own extension and use it.

Regards,

Kaushik Solanki

Re: how to create pie chart with multiple measures

Mon, 04 Apr 2016 05:29:48 GMT

Hi Kaushik,

Can you please tell me how to create my own extension ?

Re: how to create pie chart with multiple measures

kaushiknsolanki — Mon, 04 Apr 2016 08:49:22 GMT

Hi,

There are so many blogs which will guide you how to create extensions.

Qlik Sense - Introduction to Extensions (video)

Regards,

Kaushik Solanki