Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aviadbein
New Contributor II

Conditional Display and "Other" aggregate issue

Hi all,

Iv'e got some peculiar issue with the Conditional Display that I would be very grateful if someone could help me with.

I've got DB of 1 table with 3 Fields (Attached): Cust (String), A (Numeric), B (Numeric). and the following Inline table:

CondQ1.png

In the app I created a variable (vAmountType) in order to make the Conditional Display:

CondQ2.png

In the app there is a Donut chart with Dimension = Cust and the following conditional Measure (Amount):

CondQ3.png

Now, for the problem:

CondQ4.png

As you probably notice, when i choose to limit the Dimension to TOP 10 with "Show others" and choose the Conditional Display Field as AmountType=1, the top 9 field values are display the correct data - sum(A),

but the Others Value, that is calculated on measure: Amount automatically, Display the incorrect aggregated data - sum(B).

What I did wrong, and why the condition in the variable/calculation is not persistent and change by himself in Others view?

Thanks in advance,

Aviad