Calculated Dimension in Barchart

[#1]

Hi Guys,

I want to create a chart with two dimensions(Report Month, Category) , Category contains one calculated Value (NICO)
Now Dimensions are : Report Month
                     Category_Name(Dispute, Legal Dispute, Collectible, NICO --> Calculated value in Script as below)

For the calculated dimension i created a dummy Dimension at backend by using Inline function

Load *Inline[
CategoryName, Category
Dispute, Dispute
Legal Dispute, Legal Dispute
Collectible, Collectible
, NICO
];

So by this i can able to get the NICO in Category. But the problem arises while assigning a value for NICO.

Expression used :
=if(Category='NICO',sum({<CompanyID={'C0,'c1','C2'}>}Amount),sum(Amount))

[Gysbert_Wassenaar]

I don't understand what you're trying to do. Can you post a Qlik Sense .qvf document that demonstrates the problem?

[#3]

In this Below post I added a sample File. Please keep post your analysis on this issue.

http://community.qlik.com/thread/154267