Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Chujunnnnn
Contributor
Contributor

Pivot Table - Not able to show measures

Hi,

I am trying to do some pivot tables for different services.

The idea is to show for each service, what are the detected results for each service, and how many times it detected for the result.

The expected output (currently working, service 1) is as follow:

4.JPG

=========================================================================

Originally I can see the selection and the measure (validation records),

1.JPG

the measure and selection is gone after I added another diamension,

 

2.JPG

the selection and measure appear again if I remove the "count" funcion, but I need the count function. 

3.JPG

May I know how to solve this?

Labels (2)
1 Solution

Accepted Solutions
zzyjordan
Creator II
Creator II

Hi, Chujunnnnn
You just need drag your pivot table a little bigger so the measure column will show up again, as qlik sense regards that there is no enough space to display the measure value in this case

ZZ

View solution in original post

4 Replies
zzyjordan
Creator II
Creator II

Hi, Chujunnnnn
You just need drag your pivot table a little bigger so the measure column will show up again, as qlik sense regards that there is no enough space to display the measure value in this case

ZZ
Chujunnnnn
Contributor
Contributor
Author

LOL. Okay. It is working now. Thank you so much.

Chujunnnnn
Contributor
Contributor
Author

LOL. Okay. It is working now. Thank you so much.
zzyjordan
Creator II
Creator II

Cool, I am glad to help.