topic Re: Need help with Pivot Table in QlikView

Need help with Pivot Table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Need help with Pivot Table

Anonymous — Wed, 31 Aug 2016 08:52:47 GMT

Any sample Data?

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?

Re: Need help with Pivot Table

punitpopli — Wed, 31 Aug 2016 09:06:46 GMT

hi sharmabi‌

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

Hope this will help.

Thanks,

Punit

Re: Need help with Pivot Table

Anonymous — Wed, 31 Aug 2016 09:20:50 GMT

Provide sample data