Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

calvindk
Contributor III

How can i deal with non existing (missing) values in set analysis?

I am trying to compare 2 sets to each other. I do this through set analysis and variables.

The below formula is a simplification that shows the issue.

     SUM({<CostPatternVersionTravel={'$(vProjection1)'},BudgetCopy.CostPatternVersionBudget={'$(vProjection2)'} >}

              If(IsNull(BudgetCopy.Field), 1, 2)

              )

The problem is that for some values of field, there is no values that fall within the set, resulting in an empty set.

Is there any way i can know inside the set analysis that the set is empty?

I have tried IsNull and Len but they produce no result.

If i cannot come up with a solution i will generate the missing lines with replicate values and zeroes, but i would prefer not to as that is extra data for qlikview to handle.

Thanks

1 Reply

Re: How can i deal with non existing (missing) values in set analysis?

Hi,

     Kindly upload the QVW file with sample data and also tell us what output you need.

Regards,

Kaushik Solanki

Community Browser