Am I doing it right?

Mon, 24 Jun 2013 19:51:14 GMT

I'm trying to find the percentage of one specific group of ethinic_origin vs overall ethinic_origin for a specific date. The table contains data from nearly 20 years details by starting of each month

num((Count ({<
ETHNIC_ORIGIN = {'Asian (Not Hispanic or Latino)',
'Native Hawaiian/Other Pacific Islander(Not Hispanic/Latino)',
'Black or African American (Not Hispanic or Latino)',
'Native Hawaiian/Other Pacific Islander(Not Hispanic/Latino)',
'Hispanic or Latino',
'Two or More Races (Not Hispanic or Latino)'
},
Year= {$(=max(Year))

DISTINCT [EMPLOYEE_NUMBER])/
count(DISTINCT [EMPLOYEE_NUMBER]

)), '#,##0%')

Please advice

Thanks

Re: Am I doing it right?

Gysbert_Wassenaar — Tue, 25 Jun 2013 10:11:31 GMT

You're missing a closing curly bracket for the Year filter: Year= {$(=max(Year))}. The rest looks ok to me.

topic Re: Am I doing it right? in QlikView

Am I doing it right?

Re: Am I doing it right?