Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Equivalent formulas with alternate states in expressions give different results

Hi everyone,

The two following formulas are used in a pivot table (Pivot table in default state) and usually give the same result. But, as soon as there is no possible value e.g. in Field1 due to other selections (without an active selection in Field1), the respective values are not summed up in formula 2.

To detail the example: Field1 could be the name of a sales representative that is only used in certain business units. By choosing one of the other business units Field1 has no possible value.

Formula 1:

= Sum({$}Sales)

Formula 2:

=   Sum({<Field1=[$]::Field1,

        Field2=[$]::Field2,

        Field3=[$]::Field3,

        Field4=[$]::Field4>}Sales)

Does anyone see a mistake I've done or could this be a bug?

Thanks for your help!

Tags (2)