Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-04-28 07:52 AM

How to make Pivot Table structure fixed irrespective of data available?

Hi,

I have attached snapshot here.In that table even System Type= Client & Server Owner= Business are blank then it shoiuld show '0' instead shrinking the table. Means System Type & Server Owner Column should always be fixed  irrespective of available data.I will also share a sample of data I am also sharing snapshot when it shrinks and it needs to be avoided (ipin2.png)

Thanks in advance

Preview file
6 KB
Preview file
10 KB
Preview file
11 KB
506 Views
0 Likes
2 Replies
sunny_talwar
MVP
MVP
‎2015-04-28 08:12 AM

the sample.xlsx that you have provided doesn't have IPINS_Date field in it. In addition what are the formulas you are using for each of your expressions?

413 Views
0 Likes
Anonymous
Not applicable
‎2015-04-28 08:19 AM
Author

In response to sunny_talwar

Thanks for reply

IPINS date is Start Time only.....in expression only count is used with certain filters

413 Views
0 Likes