Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Calculated Dimension in Barchart

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))

2 Replies

Re: Calculated Dimension in Barchart

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


talk is cheap, supply exceeds demand
Not applicable

Re: Calculated Dimension in Barchart

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

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

Community Browser