topic using if condition in expression in pivot table - Qlikview in QlikView

using if condition in expression in pivot table - Qlikview

sadiaasghar — Wed, 25 Nov 2020 16:16:04 GMT

Can anyone help me with this? i want to find monthly step weightage of a particular project (showing in pic below). It's working fine but value not adding in total as you can see in screenshot.

if(Len([Progress Description])<>0,

if([Progress Description]=[Sub Activities],(sUM({1<Project={'CARDS-Enablement of utility bills acceptance at PSO Outlets'}>}[Sub Activities Weightage])*100),0)

,0)

Re: using if condition in expression in pivot table - Qlikview

sadiaasghar — Mon, 31 Aug 2020 11:35:47 GMT

The total for any month is showing zero instead of 25

Re: using if condition in expression in pivot table - Qlikview

Brett_Bleess — Tue, 15 Sep 2020 17:20:15 GMT

Check out the following Design Blot post, believe that should put you on the right track on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett