topic Re: Incorrect values on selection in Qliksense in App Development

Incorrect values on selection in Qliksense

Aspiring_Developer — Mon, 22 Aug 2022 14:19:04 GMT

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

Re: Incorrect values on selection in Qliksense

BrunPierre — Mon, 22 Aug 2022 19:45:52 GMT

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)

Re: Incorrect values on selection in Qliksense

Aspiring_Developer — Tue, 23 Aug 2022 07:58:00 GMT

Hello ,

Thanks for your response

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

Re: Incorrect values on selection in Qliksense

Lakshminarayanan_J — Tue, 23 Aug 2022 08:15:40 GMT

@Aspiring_Developer

Kindly Try as below and let us know ,

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

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

Re: Incorrect values on selection in Qliksense

Aspiring_Developer — Tue, 23 Aug 2022 08:22:22 GMT

Hi @Lakshminarayanan_J

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

Re: Incorrect values on selection in Qliksense

BrunPierre — Tue, 23 Aug 2022 08:25:10 GMT

@Aspiring_Developer What's the denominator there?

Re: Incorrect values on selection in Qliksense

Aspiring_Developer — Tue, 23 Aug 2022 08:26:48 GMT

Hi @BrunPierre

denominator

Re: Incorrect values on selection in Qliksense

BrunPierre — Tue, 23 Aug 2022 08:33:13 GMT

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

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

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

Re: Incorrect values on selection in Qliksense

Lakshminarayanan_J — Tue, 23 Aug 2022 09:01:50 GMT

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

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

Re: Incorrect values on selection in Qliksense

Aspiring_Developer — Tue, 23 Aug 2022 10:17:48 GMT

Hello @BrunPierre

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

Thanks

Re: Incorrect values on selection in Qliksense

Aspiring_Developer — Tue, 23 Aug 2022 10:24:57 GMT

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

Re: Incorrect values on selection in Qliksense

Lakshminarayanan_J — Tue, 23 Aug 2022 10:48:58 GMT

@Aspiring_Developer

Kindly use the below expression, and let us know

Sum(Volume)

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

Re: Incorrect values on selection in Qliksense

Aspiring_Developer — Tue, 23 Aug 2022 13:48:06 GMT

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

Re: Incorrect values on selection in Qliksense

Lakshminarayanan_J — Wed, 24 Aug 2022 06:58:42 GMT

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

Re: Incorrect values on selection in Qliksense

Aspiring_Developer — Wed, 24 Aug 2022 07:08:59 GMT

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

Re: Incorrect values on selection in Qliksense

Lakshminarayanan_J — Wed, 24 Aug 2022 07:16:54 GMT

@Aspiring_Developer

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

Re: Incorrect values on selection in Qliksense

Aspiring_Developer — Wed, 24 Aug 2022 07:35:37 GMT

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