Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

crosstable

Allow everyone,

Im making a report about a questionnaire.

The database is filed like that:

Id , Question 1-A, question 1-B, question 1-C, question 1-D

1, A, B, C , D

2, B, A, C, D

3, D, A, C, E

...

400, D, A, B, A

Then i want to make a table or a grah like this:

Rows\Columns A B C D E Total

Question 1-A 30% 20% 10% 5% 35% 400

Question 1-B

Question 1-C

Question 1-D

I tryied in the dimension to Aggregate (question 1-A, Question 1-B, Question 1-C, Question 1-D)

Then i wrote in the 1st expression i count(Question 1-A ) ;

2nd expression count (question 1-b), etc.

The result isn't what i pretended because it doesnt give me all the answers that is possible.

I attacht i file to see if someone could help me.

Thanks a lot,

Eliano Marques

1 Reply
neetu_singh
Partner
Partner

Hi,

Please find the attached file. Hope it will help you.

if not, plz let me know.

Regards

Neetu SIngh