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

[Aspiring_Developer]

Hi @Lakshminarayanan_J 

I tried your below expression and it seems to work as my numbers are now not changing on selections :-

Sum(Volume)

/

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

But now, it is not filtering the data properly.

For instance, when I select April 2022 and Brand BT it should only show the data for these selections but as you can see in my screenshot, it is showcasing the data for other dates and brands as well . 

Can you please help ?

Thanks in advance

[Lakshminarayanan_J · Accepted solution]

@Aspiring_Developer 

Kindly use the below expression, and let us know 

Sum(Volume)

/

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

[Aspiring_Developer]

Hi @Lakshminarayanan_J 

Many thanks for your response. Your solution worked.

On this data set, I am trying to bypass one more filter so that it should not change my values.

I have one filter named 'Category' and when I am selecting anything from it, it is changing my values . I tried using the same expression as your solution suggest and added this field like below :-

But it didn't worked.

Ideally it should remain be 24% i.e values should not change like below :-

Can you please help ?

Thanks in advance

[Lakshminarayanan_J]

@Aspiring_Developer 

Try the below one and let us know , Qliksense is case sensitive , Field name should be same in expression , Even if  it small or capse 

Sum(Volume)

/

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

[Aspiring_Developer]

Hi @Lakshminarayanan_J 

Thanks for your response. I tried your expression and even checked the case sensitive thing but it is still changing my result on category filter . Please see below :-

Thanks

[Lakshminarayanan_J]

@Aspiring_Developer 

 Okay, Kindly share me the sample data ,so that we will work on it and keep you update.

[Aspiring_Developer]

Hello @Lakshminarayanan_J 

PFA my data set.

Below are the details of my table visuals that I am trying to create :-

Dimension - Month Year | Brand

Measure - 

Sum(Volume)

/

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

Sorry, forgot to mention one more point, in the above measure I have used 'relative number ' option available in qlik. So my original values were like below :-

Then I followed below steps :-

1) went inside the measure and selected below :-

Got below output :-

2) Later changed the Number format to percentage and got these values :-

Thanks in advance