AGGR()

[Anonymous]

Hi my name is Andrea,

I would like to understand how to solve this issue.

Category	Supplier	Purchase	Tot Purchase	Purchase %
1	A	1000	6000	16%
1	B	2000	6000	34%
1	C	3000	6000	50%
Tot		6000		100%
2	D	1000	3000	33%
2	E	2000	3000	67%
Tot		3000		100%

If i use this formula: aggr(NODISTINCT sum(Purchase),Category) i can get the column "Tot Purchase" and "Purchase %" as in the table. But if i click on a supplier (for example supplier A) the Tot Purchase becomes 1000 and Purchase % becomes 100%.

Is there any solution for this issue?

I would like to click on a supplier and mantain the same result.

Thanks to all in advanced.

Andrea

[Anonymous]

Thanks for the answer.....this comumunity is awesome!

I Will try this solution as soon as i can.

Could you please explain me the difference in using <category > and {<category>} ?

[sunny_talwar]

<category> is used with TOTAL qualifier to tell the expression that the Total need to be calculated for each category.

{<category>} is a set analysis syntax(similar to {<category =>} used to ignore selections in category field.

[Anonymous]

Hi at the end i use this: 

fractile(total <Categoria> {<[Ragione sociale]>} Aggr(Sum({<[Ragione sociale]>}Acquistato)/Sum(TOTAL <Categoria> {<[Ragione sociale]>} Acquistato), Categoria,[Ragione sociale]),0.25)

Where:

Categoria = Category

Ragione sociale = Supplier

Acquistato = Purchase

It's look like good because now when i select a supplier the relative fractile is correct 

[sunny_talwar · Accepted solution]

Awesome, I am glad you were able to figure it out .

If you got everything you were looking for, I would ask you to close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny