Regarding Pie chart

[#1]

Hi team,

Am new to qlik sense . I need to create one pie chart based on below requirement.

For example my pivot table contains 4 fields like item id,vendor_name ,Buyer_name,Spend_Amount,when I have to create pie chart it will not show item id.It should show vendor_name and Spend_amount.

Thanks in advance.

Thanks,

Srujana.

[#2]

Hi Rahul,

I am expecting one more help from you, Am using transpose functionality in Pivot table .its working fine but when we convert bar chart its not working. Please find the attached screen shot

Thanks,

Srujana.

[rahulpawarb]

Hello Srujana,

Please follow below steps:

1. Load the data using CrossTable functionality

NewData:
CrossTable(Type, Amount)
LOAD * INLINE [
Item Id, Total Spend, Savings Amount, Actual Amount
Item1, 1000, 300, 700
];

2. Create new Bar Chart with Type as Dimension and Sum(Amount) as Measure

3. Create a Pivot Table with Type as Row and Sum(Amount) as Measure

Hope this will be helpful.

Regards!

Rahul

[#4]

Hi Rahul,

Thanks for your reply.

I have data in excel already, based on data am created a  pivot table.Its working fine now we have to convert this pivot to bar chart.But in this case we didn't get the bar chart as per our data,Item id is taken in X-axis and Savings are taken in Y-axis.In our case item_id taken in Y-axis and savings are taken in x_axis.Please find the screen shot.

[rahulpawarb]

Hello Srujana,

Could you please share your application with sample data?

Regards!

Rahul