topic Re: bar chart in qlikview in QlikView

bar chart in qlikview

sadiaasghar — Fri, 15 Nov 2024 23:52:09 GMT

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

Re: bar chart in qlikview

Anil_Babu_Samineni — Fri, 02 Oct 2020 06:47:10 GMT

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

Re: bar chart in qlikview

sunny_talwar — Fri, 02 Oct 2020 17:16:31 GMT

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