Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
KevSan
Contributor II
Contributor II

Benchmarking question

Hi everybody,

I need your help. I'm trying to conceive a table where :

- Column 1 = Turnover for selected supplier

- Column 2 = Turnover for category(ies) of selected supplier (so, turnover for all the suppliers in the categories)

 

How can I do that? 

PS: Calculation of my turnover is in a variable 

 

Can someone help me?

Have a nice day.

Labels (1)
1 Reply
KevSan
Contributor II
Contributor II
Author

I tried this 

Sum({1<Category =P(Category),$(vSelectCurrentYear(0))}>}Qty)

 

It seems to be all right but I can't understand what I did, so i'm not comfortable.

 

Could you please help me?

 

Thanks