Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
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
Contributor II
Contributor II

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?