Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator III
Creator III

Incorrect values on selection in Qliksense

Hello All,

I have below table :-

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

Aspiring_Developer_0-1661177513949.png

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

Aspiring_Developer_1-1661177586936.png

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 :-

Aspiring_Developer_2-1661177792505.png

 

Aspiring_Developer_3-1661177856419.png

 

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

 

Labels (1)
16 Replies
Aspiring_Developer
Creator III
Creator III
Author

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)

Aspiring_Developer_2-1661250205023.png

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

@Aspiring_Developer 

Kindly use the below expression, and let us know 

Sum(Volume)

/

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

 

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
Aspiring_Developer
Creator III
Creator III
Author

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 :-

Aspiring_Developer_0-1661261306173.png

But it didn't worked.

Aspiring_Developer_1-1661262140125.png

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

Aspiring_Developer_2-1661262467450.png

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)

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
Aspiring_Developer
Creator III
Creator III
Author

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 :-

Aspiring_Developer_1-1661324930825.png

 

Aspiring_Developer_0-1661324893530.png

 

Thanks

Lakshminarayanan_J

@Aspiring_Developer 

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

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
Aspiring_Developer
Creator III
Creator III
Author

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 :-

Aspiring_Developer_0-1661326247746.png

 

Then I followed below steps :-

1) went inside the measure and selected below :-

Aspiring_Developer_1-1661326297882.pngAspiring_Developer_2-1661326389293.png

 

Aspiring_Developer_3-1661326433053.png

 

Got below output :-

Aspiring_Developer_4-1661326462877.png

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

Aspiring_Developer_5-1661326507752.png

 

Thanks in advance