Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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