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)
1 Solution

Accepted Solutions
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

View solution in original post

16 Replies
BrunPierre
Partner - Master
Partner - Master

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
Creator III
Creator III
Author

Hello ,

Thanks for your response 

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

Aspiring_Developer_0-1661241472817.png

 

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)

 

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 and it is giving me below error:-

 

Aspiring_Developer_0-1661242891164.png

Aspiring_Developer_1-1661242901828.png

 

BrunPierre
Partner - Master
Partner - Master

@Aspiring_Developer  What's the denominator there?

peter_brown_0-1661243098326.png

 

Aspiring_Developer
Creator III
Creator III
Author

Hi @BrunPierre 

denominator

Aspiring_Developer_0-1661243199214.png

 

BrunPierre
Partner - Master
Partner - Master

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)

 

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 @BrunPierre 

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

Aspiring_Developer_0-1661249821331.pngAspiring_Developer_1-1661249853381.png

Thanks