Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
Not applicable

BUG? Calculate for the first line but do not for the others...

Hi guys!

I am having a problem in a simple table in QlikSense 3.1.

I have to calculate quartiles and it does perfectly for the first line of the table (the first category = 'Restaurante'), but it doesn´t for the other lines...

Does anyone have any idea of how to solve this issue???

problem.PNG

In this case the calculation for 'Restaurante' is made just fine, but the other lines are not calculated.

3quartile.PNG

If I change the order in my dimension (ValeuList) and put the 'Bebidas' category in the ValueList before the 'Restaurante' Category, it calculates for the first one ('Bebidas') and don´t calculate for the other lines ('Restaurante')....

bebidas.png

I have no idea why QlikSense can´t do the same calculation for the other lines..

If someone have any clue for this problem please help me!!

Thanks in advance!

Tags (1)
1 Solution

Accepted Solutions

Re: BUG? Calculate for the first line but do not for the others...

Try using NODISTINCT after Aggr() function in your expression....

Q-Tip # 14 – AGGR() and Synthetic Dimensions | Natural Synergies

2 Replies

Re: BUG? Calculate for the first line but do not for the others...

Try using NODISTINCT after Aggr() function in your expression....

Q-Tip # 14 – AGGR() and Synthetic Dimensions | Natural Synergies

Not applicable

Re: BUG? Calculate for the first line but do not for the others...

Sunny, thank you so much!!!!!!

You saved me! It is working now and I can delivery what I wanted

Thank you very much for the quick and correct answer!