Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
kishoreravi1983
New 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

 

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Set Analysis

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

- Marcus

3 Replies
Channa
Contributor III

Re: Set Analysis

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
MVP & Luminary
MVP & Luminary

Re: Set Analysis

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

- Marcus

kishoreravi1983
New Contributor III

Re: Set Analysis

Thanks Markus. This Worked