Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
I don't understand what you're trying to do. Can you post a Qlik Sense .qvf document that demonstrates the problem?
In this Below post I added a sample File. Please keep post your analysis on this issue.