Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
kishoreravi1983
Contributor III
Contributor III

Set Analysis

Hi All,

 

I have a small Issue while writing Set Analysis

This is My exp displayed in KPI Object

Avg({<ReferenceDate={'EDACloseCompleteDate'},EffortType={'Research/POC'}>}DataWranglingDays)+
Avg({<ReferenceDate={'ETCloseCompleteDate'},EffortType={'Build'}>}[EDA-GovDays]) +
AVG({<ReferenceDate={'POC-BuildDecisionDate'},EffortType={'Build'}>}[POC-BuildDays])

 I am summing up all the Avg Days, but what the issue if due to filter if any column doesn't meet the selection it is Showing blank. but other two i have values. I would want to display Values of Others if one is not meeting the criteria of selection on Front end.

Let me know how to correct the expression.

Thanks

Ravi

 

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Try it with: rangesum(avg1, avg2, avg3) instead of: avg1 + avg2 + avg3.

- Marcus

View solution in original post

3 Replies
Channa
Specialist III
Specialist III

expression looks good try to make as suppurate and see which one has problem

try use = before expression and use open close for each expression

Channa
marcus_sommer
MVP & Luminary
MVP & Luminary

Try it with: rangesum(avg1, avg2, avg3) instead of: avg1 + avg2 + avg3.

- Marcus

View solution in original post

kishoreravi1983
Contributor III
Contributor III
Author

Thanks Markus. This Worked