Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Calculation of market share

Hi,

 

I would like to calculate the number of units Vs the category. for example

 

(sum(unit_quantity*quantity_delivered)
/
Sum({<[Subcategory2]={GetFieldSelections(Subcategory2)}>} unit_quantity*quantity_delivered))-1

If I select my brand XX who's is in the Subcategory2: cookies

I would like to calculate the amount of "my" cookies (because I selected my brand in the brand list) Vs the amount of all cookies (that has not been selected in any Subcategory2 List)

 

Thank's for your help

 

10 Replies
sunny_talwar

Sorry my friend, I don't understand... may be someone else can help.