Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
sagar_vij99
Creator
Creator

Chart expression using Set Analysis for multiple dimensions

Hi,

I am making a chart which have 2 dimensions one is Tenure_of_Emp and other is Business_Unit. I am using an expression where I am counting number of employees (count([person number]). Now i want the chart to show % of employees as per different buckets on business unit dimension. As of now i used count([person number])/count({1}[person number]) and it gives me 100% for every bucket(i understand it sums up as per business unit but not as total).

below is the screenshot of chart. can anyone help me out here?


Capture.JPG

12 Replies
sagar_vij99
Creator
Creator
Author

Hi Neelima,

Thanks for the reply but sum was required to be replaced with count.

sagar_vij99
Creator
Creator
Author

This is what i was looking for. Thanks a ton..!!

sunny_talwar

Great, please close the thread by marking correct and helpful responses

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny