bar chart in qlikview

[sadiaasghar]

I have KPI data for each project but projects are further sub-divided into several sub-projects and if a project has more than one sub-projects I have Dept KPI for that specific projects. So in my chart I want Marginal, Par, Focus, Wow trendlines, i have applied condition IF Dept KPI is null, EVALUATE 1st expression otherwise calculate 2nd but it's only working for 1st expression. Please help. I am attaching qvw document for reference. @sunny_talwar ,@Kushal_Chawda Please look into this

if(isnull([Dept KPI]),

Concat({<[KPI]={'Marginal'}>}[Weightage Description (Text)],chr(10),[Project]),

Concat({<[Dept KPI]={'Marginal'}>}[KPI Value],chr(10),[Sub-Project]))

[Anil_Babu_Samineni]

Can you explain what case it is not working? May be with screenshot or brief description.

[sunny_talwar · Accepted solution]

@sadiaasghar may be this

Aggr(If(IsNull([Dept KPI]),
	Concat({<[KPI] = {'Marginal'}>} [Weightage Description (Text)], Chr(10), [Project]),
	Concat({<[Dept KPI] = {'Marginal'}>} [KPI Value], Chr(10), [Sub-Project])
), [Sub-Project])