Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

using if condition in expression in pivot table - Qlikview

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)

sadiaasghar_0-1598871303170.png

 

2 Replies
Contributor
Contributor

The total for any month is showing zero instead of 25

Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.