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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
chiso_chiso
Creator
Creator

Cross Table Count and Average

Kindly assist.

Using the attached, I have loaded my Data as a Cross table but I can not proceed from there. I have loaded the attributes as Questions and the Data as Answers.

I want to determine the count of Yes' and Nos for every question and establish the average i.e. TotalCountYes/TotalCountShopName

1 Solution

Accepted Solutions
Not applicable

Dear Harrison,

Please try the attached QVW for Solution:-

In Straight Table take Questions as Dimension and use three expressions:-

Yes:- count({$<Answers={'Yes'}>}Answers)

No:-  count({$<Answers={'No'}>}Answers)
Average:- count({$<Answers={'Yes'}>}Answers)/count([Shop Name])

Thanks & Regards

Prince Anand

View solution in original post

5 Replies
Not applicable

Dear Harrison,

Please try the attached QVW for Solution:-

In Straight Table take Questions as Dimension and use three expressions:-

Yes:- count({$<Answers={'Yes'}>}Answers)

No:-  count({$<Answers={'No'}>}Answers)
Average:- count({$<Answers={'Yes'}>}Answers)/count([Shop Name])

Thanks & Regards

Prince Anand

chiso_chiso
Creator
Creator
Author

Thanks Prince,

How do I eliminate the blanks in my count?

Not applicable

Dear Harrison,

By default It don't count Blans,So you not need to eliminate blanks.

Thanks & Regards

Prince Anand

chiso_chiso
Creator
Creator
Author

Thanks a lot Prince Anand

Not applicable

Welcome Harrison