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: 
Not applicable

Is it possible to have a Pivot table without an expression?

Hi Everyone,

2 questions:

1) In Excel, you're able to have Dimensions in a pivot table, without any calculation Expression, and it would just show all the values of those Dimensions.  That doesn't seem to be possible in Qlikview. Or, is it?

2) How can you make the pivot table Dimensions expand automatically, without having to click on the little + sign everytime?

Thank you for your expertise.

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi Trung,

Response to your question:

1. Yes for sure. That can be done in QlikView. Just add dimension without expression, but you need to uncheck "Suppress Zero-Values" in Presentaion tab.

Untitled.png

2. To do full expand in Pivot table in QlikView, we can:

     a. Check "Always Full Expanded" (See figure 3 in picture above)

     b. Or right click on column in pivot table -> Expand All

Regards,

Sokkorn

View solution in original post

3 Replies
Sokkorn
Master
Master

Hi Trung,

Response to your question:

1. Yes for sure. That can be done in QlikView. Just add dimension without expression, but you need to uncheck "Suppress Zero-Values" in Presentaion tab.

Untitled.png

2. To do full expand in Pivot table in QlikView, we can:

     a. Check "Always Full Expanded" (See figure 3 in picture above)

     b. Or right click on column in pivot table -> Expand All

Regards,

Sokkorn

Not applicable
Author

Sokkorn, thank you.

Not applicable
Author

Hey guys, 

I am given a task to calculate the frequency of calls across a territory. If the rep called a physician regarding the sale of the product 5 times, then frequency is 5 and HCP count is 1....I generated frequencies from 1 to 124 in my pivot table using a calculated dimension which is working fine. But my concern is :

My manager wants frequencies till 19 in order from 1..2..3..4...5..6.....19...

And from the frequency 21-124 as 20+.

I would be grateful if someone helps me with this.....Eager for the reply....