Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need help with Pivot Table

Hi Team,

We have a requirement to showcase data in pivot table and for that i need help in writing expression. We have a skill survey data in which people from different geographical regions has filled the survey form. There are approxametly 65 questions in survey form and each question has 4 options as below.

-No-Knowledge

-Begineer

-Intermediate

-Advanced

I have created a pivot table in which I have selected the dimensions as Application, Region and in the expression i want to show count of users falling under either of category based on below assumption.

1) Out of 65 questions, 1 user has selected answered 53 questions as "No knowledge",10 questions as intermediate, 1 as begineer and 1 as advanced. We need to compare this values with total 65 and since "No Knowledge"(53 answers) is > 80%of65(which is 52), This guy should fall under "No Knowledge" category. Similarly we need to count how many users fall under "No Knowledge", "Intermediate", Begineer or Advanced category for each Region.

Regards

Bibhu

3 Replies
Anonymous
Not applicable
Author

Any sample Data?

or

You can write 4 expression for , like?

-No-Knowledge


Expression: count({<Options={'No-Knowledge'}>} distinct UserID)

Similarly for others as well..Will this make sense?

punitpopli
Specialist
Specialist

hi sharmabi

You can use a dimension as column (pivot table functionality, refer screen shot below) and can use sum(measureName) as expression.

Untitled.png

Hope this will help.

Thanks,

Punit

Anonymous
Not applicable
Author

Hi

Provide sample data