Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kranthi_bhattu
New Contributor

Set Analysis: Counting wrongly

Hi,

Lets Say Table A , Table B has the following definition and Data.

Table A

Country  Sales

A               100

B                200

C               300

D               400

Table B ( Data Island)

Countryy

-Consolidate-

A

B

C

D

and set analysis expression is as following:

=num(Sum({$<[Country]=P([Countryy])>}Sales),'#,##0')

However on non filter mode the expression is calculating a value against '-Consolidate-'.

Why is this happening, if possible correct the expression.

The '-Consolidate-' is a user choice to see sales of countries together or individual.


Thanks,

Kranthi

Community Browser