Incorrect values on selection in Qliksense

[Aspiring_Developer]

Hello All,

I have below table :-

Measure -Sum(Volume)/
sum({<Brand-={'Total Market'}>}total Volume)

When I am selecting month year , it gives me below results  which is incorrect:-

So ,in order to keep the values static on Month Year selection, I passed this dimension in aggregation . Used below expression :-

Sum(Volume)/
sum({<Brand-={'Total Market'}>}total <MonthYear> Volume)

When I used the above, it results started coming fine. Now when I select any month year , my results are not changing.

However, when I am selecting anything from Brand filter, my measure values are changing like below :-

I don't want my values  to change on Brand and Month Year filter selection . It should be static .

How can I achieve it ?

Thanks in advance

[BrunPierre]

Use these modified expressions as they disregard all selections made in both Branch and MonthYear dimensions.

SUM({<Brand=,MonthYear=>}Volume)

/

SUM({<Brand={'*'}-{'Total Market'},MonthYear=>} Volume)

[Aspiring_Developer]

Hello ,

Thanks for your response 

I tried your expression and it gives me below output :-

[Lakshminarayanan_J]

@Aspiring_Developer 

Kindly Try as below and let us know ,

Sum(Volume)/sum({$<Brand-={'Total Market'}Brand=,MonthYear=>>}total Volume)

or

Sum({1}Volume)/sum({1<Brand-={'Total Market'}Brand=,MonthYear=>>}total Volume)

[Aspiring_Developer]

Hi @Lakshminarayanan_J 

Thanks for your response. I tried and it is giving me below error:-

[BrunPierre]

@Aspiring_Developer  What's the denominator there?

[Aspiring_Developer]

Hi @BrunPierre 

denominator

[BrunPierre]

I suggested this earlier, both numerator and denominator. What's the feedback?

SUM({<Brand=,MonthYear=>}Volume)

/

SUM({<Brand={'*'}-{'Total Market'},MonthYear=>} Volume)

[Lakshminarayanan_J]

Apologies , Kindly set the value 1 before < as shown below,

Sum({1}Volume)/sum(1{<Brand-={'Total Market'}Brand=,MonthYear=>>}total Volume)

[Aspiring_Developer]

Hello @BrunPierre 

I Tried your expression but it is not giving me any values . Please see below :-

Thanks