topic Re: Calculated Dimension in Bar chart in QlikView

Calculated Dimension in Bar chart

Thu, 26 Feb 2015 16:13:16 GMT

Hi Community,
I wnat 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))

Re: Calculated Dimension in Bar chart

chrismarlow — Thu, 26 Feb 2015 16:21:59 GMT

I am not sure I follow. Is 'CategoryName' in your table with CompanyID & Amount, in which case your inline table won't join properly, you would need to get the possible CategoryNames for NICO and include in your inline.

Re: Calculated Dimension in Bar chart

MK_QSL — Thu, 26 Feb 2015 16:34:47 GMT

Try

=If(IsNull(CategoryName),

SUM({<CompanyID={'C0,'c1','C2'}>}Amount),

SUM(Amount)

)

Re: Calculated Dimension in Bar chart

Thu, 26 Feb 2015 16:37:10 GMT

NICO is not a Category but still i want this to be appear in Chart, That's why i created a calculated dimension

Re: Calculated Dimension in Bar chart

Thu, 26 Feb 2015 16:49:10 GMT

No, It's not displaying. Instead of giving SUM({<CompanyID={'C0,'c1','C2'}>}Amount), I tried giving one value "50.16". That time, It shows the value for Report_Month = null value. but not showing for other report months.

Re: Calculated Dimension in Bar chart

MK_QSL — Thu, 26 Feb 2015 16:53:44 GMT

Can you provide sample apps please?

Re: Calculated Dimension in Bar chart

chrismarlow — Thu, 26 Feb 2015 16:58:21 GMT

I am still struggling with exactly what you need. If you simply want to reclassify those 3 CompanyIDs as NICO then I think the attached might be a step towards that.

Re: Calculated Dimension in Bar chart

Thu, 26 Feb 2015 17:02:29 GMT

See if this works. sum({<CompanyID={'C0,'c1','C2'},Category=>}Amount)

Re: Calculated Dimension in Bar chart

manojkulkarni — Thu, 26 Feb 2015 18:24:28 GMT

not getting exactly to your problem. can you upload your app here.

Re: Calculated Dimension in Bar chart

Anonymous — Thu, 26 Feb 2015 18:42:25 GMT

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

Re: Calculated Dimension in Bar chart

Thu, 26 Feb 2015 19:10:02 GMT

It seems, it is working. Some of the companies will fall under "NICO" Criteria. So I want to show them in Seperate Stack of Bar. As you Said if(match(CompanyID,'C0','C1','C2','C3'>0, "NICO',CategoryName) is parfectly working as i want.

Hope it is understandable. Soon i will post .qvw file with some sample data

Re: Calculated Dimension in Bar chart

Thu, 26 Feb 2015 19:27:54 GMT

Hi Team,

I have added a sample report for better understanding. Hope it helps...

Re: Calculated Dimension in Bar chart

Thu, 26 Feb 2015 19:28:33 GMT

Thank you for your help